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 .....
Practise OCR GCSE Computer Science Additional programming techniques with exam-style questions for GCSE Computer Science. 5 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.