Clean Latency Cast

A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

easy

Seniority

mid

Problem

During a data quality investigation, you found that the latency column in service health records contains some non-numeric strings. Return all records with latency converted to an integer, excluding any rows where the conversion would fail. Return all available fields.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.