A)

Create the following view:

CREATE VIEW BSAD_COURSE AS SELECT * FROM BSAD384.DBO.COURSE WHERE DEPTCODE='BSAD'

in one sentence what is this doing

B)

Run a query to select all columns from BSAD_COURSE where the coursename has the string 'Business' anywhere.

Paste your SQL statement here

C)

CREATE VIEW BUILDING_ROOM AS SELECT DISTINCT building, roomno FROM BSAD384.dbo.building b, BSAD384.dbo.section s WHERE b.bcode = s.bcode 

What do you think this view does?

D)

Run a query on BUILDING_ROOM to select rooms from Nicholson Hall ordered by Roomno

Paste your query here (assume bcode for nicholson hall=nh)

E)

Create a view called GRADE_FAIL selecting all columns, from tables student and enroll that include columns fname,lname,CRN,year and grade where grade is less than 50

Paste your SQL Statement here

F)

Run a query based on GRADE_FAIL view to list fname, lname and average failing grade for students whose last name strats with MacK and sort in descending order of AVG grade (Group By)

G)

Change the format of AVG(GRADE) to 99.99.

Paste your query here