Homework 5 questions

Question 2

There is no OrderID in both Order and Customer sheets.

That is correct! I misread the column names when I was putting this HW together. The HW file has been fixed!

Question 3

There is no OrderID in each sheet.

Again, that is correct, and has been changed in the updated HW file.

Question 4

Do we have to return 4 columns in total namely JobTitle, NumberOf Employees, Average vacation hours, average vacation days for each job title?

Nope, days is a typo! Please return 3 columns: JobTitle, NumberOfEmployees, MeanVacationHours.