$1.$ Create $10$ temp tables using Adventureworks Database.$$

$2.$ Create the same $10$ tables as CTE$$s$.$

$3.$ Create the same $10$ tables as Table Variables.

Once you create a query, you will store it in all $3$ Temporary Data Structures.$$ You can pick the AdventureWorks tables but they must match the following formats:

Query $1-$ Must use the LIKE and BETWEEN operators.

Query $2$ Must use the IN and NOT IN operators.

Query $3$ Must use a GROUP BY Statement and $2$ aggregates $($Temp table should be built using SELECT INTO Statement.

Query $4$ Must use the UNION operator.

Query $5$ Must be built using at least one column that is a Primary Key with an Identity Column.

Query $6$ Must be built using a WHERE clause and ORDER BY clause.

Query $7$ Must be built using a GROUP BY clause and HAVING Clause.

Query $8$ Must be built using WHERE $/$ GROUP BY $/$ HAVING $/$ ORDER BY clauses

Query $9$ Must be built using $3$ System Functions.

Query $10$ Must be built using $3$ other System Functions.