ORDER BY multiple columns in MySQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to order the results by the column 'age' in ascending order.

MySQL

SELECT * FROM users ORDER BY [1];

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

Aage

Bname

Csalary

Did

Attempts:

3 left

💡 Hint

Common Mistakes

Using a column name that does not exist in the table.

Forgetting to specify the column after ORDER BY.

The ORDER BY clause sorts the results by the specified column. Here, we want to sort by age.

2fill in blank

medium

Complete the code to order the results by 'age' ascending and then by 'name' ascending.

MySQL

SELECT * FROM users ORDER BY [1], name;

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

Aage

Bsalary

Cid

Ddate_joined

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the order of columns.

Using a wrong column name.

To order by multiple columns, list them separated by commas. Here, the first column is age.

3fill in blank

hard

Fix the error in the code to order by 'age' ascending and 'name' descending.

MySQL

SELECT * FROM users ORDER BY age, [1] DESC;

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

Asalary

Bid

Cname

Dage

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong column name.

Placing DESC before the column name.

The second column to order by is name, and it should be sorted in descending order.

4fill in blank

hard

Fill both blanks to order by 'department' ascending and 'salary' descending.

MySQL

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

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

Adepartment

Bage

Csalary

Dname

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the order of columns.

Forgetting DESC for the second column.

The first column is department ascending, and the second is salary descending.

5fill in blank

hard

Fill all three blanks to order by 'country' ascending, 'city' ascending, and 'population' descending.

MySQL

SELECT * FROM locations ORDER BY [1], [2], [3] DESC;

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

Acountry

Bcity

Cpopulation

Darea

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing the order of columns.

Forgetting DESC for the last column.

The columns are ordered by country ascending, then city ascending, and finally population descending.