three SQL query

Job ID: 33433878

Budget: $10 – $30 USD

Write 3 queries in mssql - in detail, with explanations.
Level - middle.

Related categories: SQL MySQL Database Administration Microsoft SQL Server