Telemetry logs for a fleet of atmospheric research drones are stored in a database table called TblDroneTelemetry.
The following SQL statement is written to select all columns for telemetry records where the recorded altitude in metres (AltitudeMtrs) is strictly greater than 120.
SELECT ALL
FROM TblDroneTelemetry
IF AltitudeMtrs <= 120
The SQL statement is incorrect.
Rewrite the SQL statement so that it is correct.
Practise OCR GCSE Computer Science Programming fundamentals with exam-style questions for GCSE Computer Science. 100 questions, matched to the OCR GCSE Computer Science (J277) specification and written in Component 01 and Component 02 style. Every question includes a full worked solution and mark scheme, so you can see where marks are awarded rather than just whether you got the answer right.