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!"