HomeWork in DB

All I want is answers for HW3 which is the first attachment 

and just extra credit problem 1 and 2 and  3 from HW1 

and extra credit problem 5 from HW2 for this one u have to give me a screen shot for the tables,  the SQL,  and  the results of each of the query

DONT DO ANY QUESTIONS FROM HW1 AND HW2 except the extra credits from HW1 and extra credit problem 5 from HW2

for HW3 JUST DO THE QUESTIONS . DONT DO THE EXTRA CREDIT FROM HW3 

i HAVE ATTACHED a powerpoints notes that can help u to do HW3