$(3)$ Create four queries that satisfy the following requirements:

Query $1$: Write the business purpose of this query using a comment in SQL

$($e$.$g$./*$ or $--).$ Join data from two tables that you create with one condition in

the WHERE clause. The output must be appropriately formatted. Your query

has to make logical and business sense.

Query $2$: Write the business purpose of this query using a comment in SQL

$($e$.$g$./*$ or $--).$ Join data from the two tables that you create and use the GROUP

BY and ORDER BY clauses. The output must be appropriately formatted.

Your query has to make logical and business sense.

Query $3$: Write the business purpose of this query using a comment in SQL

$($e$.$g$./*$ or $--).$ Use one of the sub$-$queries $($i$.$e$.$ where, in$,$ having, or attribute list

subquery$)$ and at least two tables. The output must be appropriately formatted.

Your query has to make logical and business sense.

Query $4$: Write the business purpose of this query using a comment in SQL

$($e$.$g$./*$ or $--).$ Use all three tables with appropriate join condition$($s$).$ The output

should have at least one calculated column. The output must be appropriately

formatted. Your query has to make logical and business sense.

Add the commands you use to create these queries to the SQL script file that

has the commands to create tables and enter data into tables.