SQL: COUNT, SUM and GROUP BY Practice Test (Grades 6–8)
These are US practice tests (grades, CSTA standards). In the UK? Try the UK version →
A free SQL COUNT, SUM and GROUP BY test for Grades 6–8 (ages 11–14): 12 questions, graded instantly – write, fix and predict real code in your browser. No sign-up. This test is for Grades 6–8 (ages 11–14).
Before you start
12 questions on COUNT, SUM, AVG, MIN, MAX and GROUP BY, 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 graded 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
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 graded: Classfern's own checks, in your browser. Code is run in a locked box against tests, some of them hidden; nothing is graded 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.
Lines up with the CSTA K–12 Computer Science Standards (2017): 2-DA-08 – Collect data with computational tools and transform it to be more useful and reliable. The standard codes are CSTA's; the short descriptions are our own words.
More computer science tests · Programming Department · All practice tests