Visual and data

SQL queries

Pupils write SQL queries against small tables you give, and can run them to see what they return.

Marked automaticallyOn paper: a picture you mark

Good for

SELECT, WHERE, LIKE and ORDER BY, two-table queries, INSERT, UPDATE and DELETE (GCSE Computer Science).

Classfolio runs each query and compares the rows it returns with your answer's, so any correct query scores. It also tries both on hidden rows, so picking the answer rows by hand does not.

How to set it up

  1. 1In the lesson editor, choose Add slide and pick SQL queries.
  2. 2Type or paste each table: the field names on the first line, then one row a line, with commas between. Up to three tables.
  3. 3For each task, write it in words and add your SQL answer. The preview runs your answer, so you see the rows pupils must find.
  4. 4Choose whether pupils can run their query to see what it returns.
  5. 5Preview it as a pupil, then run the Readiness check before you launch: it flags anything still missing.

Tips from the classroom

  • Use realistic data with a few rows that nearly match, so the condition matters.
  • Turn off running queries for a test, so pupils cannot try until it works.