Home
Easy
Basic SELECT Query
Filtering Data with WHERE Clauses
Sorting Data with ORDER BY
Using Aggregate Functions
Grouping Data with GROUP BY
Filtering Groups with HAVING
Joining Tables (INNER JOIN)
LEFT JOIN and NULL Handling
Combining Results with UNION
Medium
Subqueries for Complex Filtering
Using CASE Statements
Sorting Data with ORDER BY
  • Description: Practice ordering data in ascending or descending order using ORDER BY. For this task, the result needs to be sorted by salary in descending order, so that employees with the highest salaries appear at the top of the list.
  • Table Used: employees
    • Columns: employee_id, first_name, last_name, department, salary
  • Expected Columns Returned: employee_id, first_name, last_name, department, salary
  • Schema:
classDiagram direction BT class Employees { integer employee_id text first_name text last_name text department float salary }

select * from employees