Not sure what I am supposed to do. All my SQL commands have errors because 'Shift' is an invalid column name.

1. Database: AdventureWorksDW Source: Call center facts Build and test the SQL to answer this question: using just the data from the AM and Midnight shifts, how many orders were placed, and how many such shifts were operated during this period? (Hint: 2 rows, 3 columns)

2. Database: AdventureWorksDW Source: Call center facts The following query can use either ROLL UP or CUBE Build and test the SQL using BOTH as two separate queries and answer this question: I need to see the average number of orders per shift along with an overall average