Examness

Beginner SQL

3 exercises · in teaching order

  1. 1Pick your columnsThe shop database has an `employees` table.SELECTFROM5m
  2. 2Filter the rowsReturn the **name** and **salary** of employees earning more than 70,000.WHEREcomparison6m
  3. 3Top three earnersReturn the **name** and **salary** of the three best-paid employees, highest salary first.ORDER BYLIMITDESC7m