Why ordering matters in SQL - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select all columns from the table ordered by the column 'age' in ascending order.

SQL

SELECT * FROM users ORDER BY [1];

Drag options to blanks, or click blank then click option'

Aname

Bsalary

Cage

Did

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a column that does not exist or is unrelated to sorting by age.

Forgetting to use ORDER BY clause.

The ORDER BY clause sorts the results by the specified column. Here, ordering by age arranges users from youngest to oldest.

2fill in blank

medium

Complete the code to order the results by 'salary' in descending order.

SQL

SELECT * FROM employees ORDER BY [1] DESC;

Drag options to blanks, or click blank then click option'

Aname

Bage

Cdepartment

Dsalary

Attempts:

3 left

💡 Hint

Common Mistakes

Using ascending order when descending is required.

Choosing a wrong column like 'age' or 'name'.

Using ORDER BY salary DESC sorts employees from highest to lowest salary.

3fill in blank

hard

Fix the error in the query to order by 'date_joined' ascending.

SQL

SELECT * FROM members ORDER BY [1] ASC;

Drag options to blanks, or click blank then click option'

Adate_joined

Bdatejoined

Cjoined_date

Djoin_date

Attempts:

3 left

💡 Hint

Common Mistakes

Using a similar but incorrect column name.

Misspelling the column name or missing underscores.

The correct column name is date_joined. Using the exact column name is necessary for the query to work.

4fill in blank

hard

Fill both blanks to order the products by 'category' ascending and then by 'price' descending.

SQL

SELECT * FROM products ORDER BY [1] [2], price DESC;

Drag options to blanks, or click blank then click option'

Acategory

BASC

CDESC

Dprice

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up ascending and descending orders.

Using the wrong column name for the first order.

The query first orders by category ASC (alphabetically) and then by price DESC (highest price first) within each category.

5fill in blank

hard

Fill all three blanks to order the sales records by 'region' ascending, then 'sales_date' descending, and finally by 'amount' ascending.

SQL

SELECT * FROM sales ORDER BY [1] [2], [3] DESC, amount ASC;

Drag options to blanks, or click blank then click option'

Aregion

BASC

Csales_date

DDESC

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping ascending and descending orders.

Using wrong column names or order directions.

The query orders sales by region ASC (alphabetically), then sales_date DESC (newest first), and finally amount ASC (lowest to highest).