Exercise set 6 - SQL basics 5

  • Northwind exercise database will be used in this exercise.
  • Return exercise in .txt format and use formatting presented below (question always followed be the query).
  • Important: This exercise requires that the following tables are created (done in previous exercise set):
    • departments
    • tasks
    • payment_methods

Download exercise template here.

Important:
  • Use only the provided exercise template for returning your answers!
  • Answers returned with any other way than using exercise template will not be evaluated.
  • Only add one query as your answer between the dashed lines without comments or any additional statements (see example below)!
  • Do not modify the structure of the exercise template!
1 | Select all employees.
--------------------------------------------------
select * from employees;
--------------------------------------------------