Reach Crest Learning

Printable worksheet ยท 4 of 4

A query asks for a defined subset - Paper 4

Read the information, then answer the questions. An adult may read the instructions aloud. Show your working where asked.

Read before answering

Supplied Courses rows (id,title,year,published): (81,'Algebra 8',10,1); (82,'Poetry 8',9,1); (83,'Cells 8',10,0); (84,'Systems 8',10,1). Query: SELECT title FROM Courses WHERE year = 10 AND published = 1 ORDER BY id. Here 1=true and 0=false. Predict this read-only query; no live database access is needed.

Worksheet preview

This exercise is included in the paid course. Full-course fee: GBP 200.00 once. Register and enrol to complete all course exercises and download the course PDFs. Access begins after payment is confirmed.

Register and enrol

Already registered? Sign in