Y11 GCSE Computer Science

SQL Queries with the World Database

Match each question to the correct SQL, then use the embedded SQL editor to query the database and record the answers you find.

Database preloaded: world.sqlite3 Real field names: name, continent, area, population, gdp, capital

Lesson flow

  1. Choose the correct SQL in Activity 1.
  2. Type each query into the SQL runner.
  3. Copy the results into Activity 2.
  4. Download a PDF of responses and model answers.
Overall progress 0 / 14 correct

Activity 1: Identify the SQL

Choose the query that matches each task. The correct answer is shuffled and is not always at the top.

SQL Editor

Type the SQL query you chose in Activity 1, click Run SQL, then use the results to complete the answer boxes in Activity 2.

Results

Waiting for the database to load.
SQL results will appear here after running a query.

Activity 2: Run the SQL and record the answers

Type the SQL from Activity 1 into the SQL runner, then transfer the answer into each box below. For lists, separate answers with commas or new lines.

Download PDF

Download a PDF with your responses, scores, and model answers.

World table

Browse the records in the preloaded world table.

The table will appear here once the database is ready.