Please help with my 2 SQL queries. Using Microsoft SQL Server Management Studio, NOT MYSQL!! Thank y

Please help with my 2 SQL queries. Using Microsoft SQL Server Management Studio, NOT MYSQL!! Thank you.

There are 5 tables total (don't have to use all of them) and their columns:

2 query instructions:

If you can't see the instructions I uploaded them here: https://files.transtutors.com/cdn/qimg/b1dc8378ed1449668946451bed446365.jpg

Thank you!

 

Looking for a Similar Assignment? Hire our Top Uk Tutors while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today! Active Discount Code FREE15