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.

Answer rating: 100% (QA)

Below are 10 SQL queries using AdventureWorks tables that match the specified formats Query 1 Using ... View the full answer