Exercise set 2 - SQL basics 1

  • Download the Northwind exercise database here
  • This database will be used for all further exercises in this course (SQL basics 1-5)
  • Download the exercise template to your computer by right-clicking the link and choose Save As.
  • Familiarise yourself with the exercise database before starting: exercise database presentation.

Download exercise template here

  • Important: Use only the template for returning your answers!
  • Add your answer queries between the dashed lines (see example below)
1 | Select all employees.
--------------------------------------------------
select * from employees;
--------------------------------------------------