Circuits Above 1,000 Metres

Easy · Formula 1 · Tables: circuits

List circuits whose numeric altitude alt is at least 1000 metres. Return integer circuit_id, name as circuit, and integer altitude_m. Exclude unknown altitudes. Return columns circuit_id, circuit, altitude_m, in that order. Order by altitude_m descending, then circuit_id ascending. All source columns have TEXT affinity: cast numeric inputs before numeric comparisons or calculations. Counts and calculated numeric outputs must be numbers, not text.

More SQL practice problems