Inventory records for a bicycle shop are stored in a database table called TblBicycles.
The following SQL statement is written to select all columns for bicycle records where the quantity in stock (InStock) is less than 3.
SELECT ALL
FROM TblBicycles
IF InStock >= 3
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.