Databases and SQL

A school keeps the details of its science fair in a database table called ScienceFair.

EntryID	Title	Category	YearGroup	Prize
SF01	Bottle Rockets	Physics	8	TRUE
SF02	Mould on Bread	Biology	9	FALSE
SF03	Solar Oven	Physics	10	TRUE
SF04	Plant Music	Biology	8	FALSE
SF05	Water Filters	Chemistry	9	TRUE
SF06	Paper Bridges	Engineering	7	FALSE
SF07	Fizzing Tablets	Chemistry	10	FALSE

All the data stored about one entry, for example everything in the row for SF04, is called a …

A branch railway line stores its morning timetable in a table called Trains.

TrainID	Destination	Platform	Departs	Express
T401	Seaview	2	07:15	TRUE
T402	Hillcrest	1	07:40	FALSE
T403	Seaview	2	08:05	FALSE
T404	Oakfield	3	08:20	TRUE
T405	Hillcrest	2	08:45	FALSE
T406	Seaview	1	09:10	TRUE
T407	Oakfield	2	09:30	TRUE
T408	Hillcrest	3	09:55	FALSE
T409	Seaview	2	10:20	FALSE
T410	Oakfield	1	10:45	FALSE

How many records are returned by this query?

SELECT TrainID, DepartsFROM TrainsWHERE Platform = 2 AND Express = TRUE;

A museum stores its dinosaur fossils in a table called Fossils. Complete is TRUE when the whole skeleton was found.

FossilID	Species	Period	LengthM	Complete	Country
FC01	Coelophysis	Triassic	2.5	TRUE	USA
FC02	Allosaurus	Jurassic	8.5	FALSE	USA
FC03	Spinosaurus	Cretaceous	14.0	FALSE	Morocco
FC04	Plateosaurus	Triassic	7.0	TRUE	Germany
FC05	Stegosaurus	Jurassic	9.0	TRUE	USA
FC06	Giganotosaurus	Cretaceous	12.5	TRUE	Argentina
FC07	Herrerasaurus	Triassic	4.5	FALSE	Argentina
FC08	Brachiosaurus	Jurassic	22.0	FALSE	Tanzania
FC09	Psittacosaurus	Cretaceous	1.8	FALSE	Mongolia
FC10	Dilophosaurus	Jurassic	7.0	TRUE	USA

The museum wants to count the fossils that are from the Jurassic or the Cretaceous period and are complete. The query starts:

SELECT COUNT(FossilID)FROM Fossils

Which line completes the query correctly?