two short answers for my sql

I have attached two pictures with two questions that need short answer. The first one is to write a query, and the second is to describe what the query would show. Please find the attached files
 
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”

 
"Is this qustion part of your assignmentt? We will write the assignment for you. click order now and get up to 40% Discount"