Activity 1: Match SQL Keywords
Drag each keyword to its correct meaning.
SELECT
FROM
WHERE
LIKE
ORDER BY
*
| Keyword | Meaning |
|---|---|
| Chooses which field(s) to return in the output. | |
| Chooses which table to read from. | |
| Filters records to only those meeting a condition. | |
Matches a pattern using a wildcard (for example, A%). |
|
| Sorts returned results (for example, ascending name order). | |
| Represents all fields in a table. |
Activity 2: Build the Query
Put the SQL clauses in the correct order for this task: return all fields from world where the name starts with A and population is over 10,000,000.
FROM world
AND population > 10000000
WHERE name LIKE "A%"
SELECT *
ORDER BY name ASC
Step 1
Drop clause here
Step 2
Drop clause here
Step 3
Drop clause here
Step 4
Drop clause here
Step 5
Drop clause here
Activity 3: Predict the Output
SELECT population FROM world WHERE name = "Albania"
Download PDF Evidence
Create a record of your starter activity responses.