Using your created database in JOINS, create queries that demonstrates the use of UNION DISTINCT and...

 

Transcribed Image Text:

Using your created database in JOINS, create queries that demonstrates the use of UNION DISTINCT and UNION ALL. Provide your query, description, and output. Save your SQL script as Activity #2- Unions- Scoring Criteria Creating a Database-query (2 points) 2 Creating 2 Tables-query (2 points) and output (1 point) 6 Inserting 5 Records in a Table-query (2 points) and ouput (1 point) 6 Using 2 Union Distinct and 2 Union All 20 -query (3 points), description (1 point) and output (1 point) Saving File-correct filename (1 point) 1 Total 35 Using your created database in JOINS, create queries that demonstrates the use of UNION DISTINCT and UNION ALL. Provide your query, description, and output. Save your SQL script as Activity #2- Unions- Scoring Criteria Creating a Database-query (2 points) 2 Creating 2 Tables-query (2 points) and output (1 point) 6 Inserting 5 Records in a Table-query (2 points) and ouput (1 point) 6 Using 2 Union Distinct and 2 Union All 20 -query (3 points), description (1 point) and output (1 point) Saving File-correct filename (1 point) 1 Total 35