Get the appApp
Learning departments Music, Maths, Cookery, Programming and Art are open – explore →

KS3 computing: SQL SELECT, WHERE and ORDER BY test – Year 9

These are UK practice tests (year groups, national curriculum). In the US? Try the US version →

A free SQL SELECT, WHERE and ORDER BY test for Year 9 (ages 13–14): 12 questions, marked instantly – write, fix and predict real code in your browser. No sign-up. This test is for Year 9 (ages 13–14).

Before you start

12 questions on SELECT, WHERE, AND, OR, NOT, LIKE, ORDER BY and LIMIT, picked from a bank of 40 each time. Some questions ask what a query gives; some ask you to write or fix a query for the table shown. When you write or fix a query, press Run to see its result. It is marked when you move on: your query is run on the table shown and on hidden tables with different rows. Choose Practice to see the answer after each question, or Test to see your answers at the end.

  • 12 questions – a new mix each time you try
  • SQL runs in your browser – nothing to install
  • A keyboard helps for the coding questions
Choose how to do it

No sign-up and no adverts. Your answers and your code stay on this device. Nothing you type in the test is sent to us – unless you choose to report a problem with a question.

How it is marked: Classfern's own checks, in your browser. Code is run in a locked box against tests, some of them hidden; nothing is marked by a person or by guesswork. Spot a mistake? Use the Report button.

Classfern practice material. Not an official test. Written by Classfern for practice. Not affiliated with or endorsed by any exam board, testing agency, school district or government department.

Curriculum: the key stage 3 computing programme of study says pupils should be taught to use 2 or more programming languages, at least one of which is textual, to solve a variety of computational problems; make appropriate use of data structures [for example, lists, tables or arrays]; design and develop modular programs that use procedures or functions.

Contains public sector information licensed under the Open Government Licence v3.0. Curriculum statements from: Department for Education, National curriculum in England: computing programmes of study, © Crown copyright 2013.

More KS3 computing tests · Programming Department · All practice tests