The tasks use a table called customers with the columns name, city and country. Try the queries for real in the SQL sandbox.
SQL basics with SELECT, WHERE and ORDER BY
Three short tasks on the first SQL keywords. Put the clauses in order, pick the right query and fill in the gaps.
Exercise15 minBachelor +2CC BY 4.0
3 tasks · 15 min
What you will learn
- Know the order of the clauses in a SELECT query
- Choose the query that answers a question
- Complete a query with the right keywords
Use it with a class
- 1. Copy the class link and share it with your class.
- 2. Learners finish the exercise and get a result code.
- 3. Paste the codes into Class results to see everyone at once.
Reuse this material
CC BY 4.0You may copy, adapt and share it, also commercially, as long as you credit ManyPI and link back.
"SQL basics with SELECT, WHERE and ORDER BY" by ManyPI (https://manypi.com/edu/sql-basics-exercise), licensed under CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/)