The database table Instruments stores details of laboratory measurement devices.
| DeviceID | Type | CalibrationStatus |
|---|---|---|
| D-104 | Spectrometer | Valid |
| D-208 | Centrifuge | Expired |
| D-301 | Spectrometer | Expired |
| D-412 | Microscope | Valid |
| D-509 | Spectrometer | Valid |
Complete the SQL query to return all fields for the instruments where the Type is 'Spectrometer'.
SELECT .....
FROM .....
WHERE .....
5 exam-style questions on OCR GCSE Computer Science Additional programming techniques. Each one has a worked solution and a mark scheme showing where the marks go.