Sql queries coursework

SELECT SALES. STUDENT_ID, SALES. STATE, SALES. YEAR, SALES. ITEM, SALES. b SQL used. SELECT SALES. STUDENT_ID, SALES. STATE, SALES. YEAR, SALES. STATE)="PA")); Q3. a total records for items: Coffee and Beer I found 9912 records for beer and coffee. Q3. b SQL used. SELECT SALES. DAY, SALES. QUANTITY FROM SALES WHERE (((SALES. STUDENT_ID)=23779685) AND ((SALES. ITEM)="Coffee" Or (SALES. ITEM)="Beer")); Q4. Month)="Nov" Or (SALES. Month)="Oct")) GROUP BY SALES. STUDENT_ID HAVING (((SALES. STUDENT_ID)=23779685)); Q5. a total sales of Beer during the weekends in PA and weekdays in NY The total sales of beer on weekends in PA, and weekdays in NY = 1238712 Q5. STUDENT_ID, SALES. ITEM, Sum(SALES. QUANTITY) AS SumOfQUANTITY FROM SALES WHERE (((SALES.

STATE)="PA") AND ((SALES. Day)="Sat" Or (SALES. STUDENT_ID, Query_Q5_NY_Weekdays. ITEM, Query_Q5_NY_Weekdays. SumOfQUANTITY, Query_Q5_PA_Weekends. SumOfQUANTITY, [Query_Q5_NY_Weekdays]![SumOfQUANTITY]+[Query_Q5_PA_Weekends]![SumOfQUANTITY] AS Total FROM Query_Q5_NY_Weekdays, Query_Q5_PA_Weekends;.