Visual and data
Pupils write SQL queries against small tables you give, and can run them to see what they return.
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.