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