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

L4

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.

Summary

The latency column is a string. It should not be.

Practice This Problem

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