How to Write in this task SQL Queries

Question

Hi Guys

Please help me

 

how to solve to this queries in SQL SERVER

Attach Photos

 

Thanks 

 

1. 

 

2.

 

3.