178|SQL – Unions with Precision

[Tessa_Staley]

Time to complete: 10 minutes
Difficulty: easy
Solution:

1. SELECT first_name, last_name, employee_email AS email
   FROM Employee
   UNION
   SELECT first_name, last_name, email
   FROM vendor;

2. SELECT *
   FROM New_Inventory
   UNION
   SELECT *
   FROM Inventory;

3. SELECT DISTINCT emp_reviewer_id AS employee_id
   FROM orders
   UNION ALL
   SELECT DISTINCT emp_order_creation_id
   FROM orders
   UNION ALL
   SELECT employee_id
   FROM Employee;

[Ashleigh_Layton]

Time to complete: 20 min
Difficulty: Easy
Solution:

1. SELECT first_name, last_name, employee_email AS email
   FROM Employee
   UNION
   SELECT first_name, last_name, email
   FROM Vendor;
2. SELECT *
   FROM New_Inventory
   UNION
   SELECT *
   FROM Inventory;
3. SELECT DISTINCT emp_reviewer_id AS employee_id
   FROM Orders
   UNION ALL
   SELECT DISTINCT emp_order_creation_id AS employee_id
   FROM Orders
   UNION ALL
   SELECT employee_id
   FROM Employee;

[Tyler_Loose]

Time to complete: 20 minutes

1. SELECT first_name, last_name, employee_email AS email
   FROM Employee
   UNION
   SELECT first_name, last_name, email
   FROM Vendor

2. SELECT *
   FROM Inventory
   UNION
   SELECT *
   FROM New_Inventory

3. SELECT DISTINCT o.emp_reviewer_id AS employee_id
   FROM Orders AS o
   UNION ALL
   SELECT DISTINCT o.emp_order_creation_id AS employee_id
   FROM Orders AS o
   UNION ALL
   SELECT e.employee_id
   FROM Employee AS e

[Tyson_Burrup]

Time to Complete: 30 minutes
Difficulty Easy
Solution
Query 1
SELECT first_name, last_name, employee_email AS “email”
FROM Employee
UNION
SELECT first_name, last_name, email
FROM Vendor;
Query 2
SELECT *
FROM New_Inventory
UNION
SELECT *
FROM Inventory;
Query 3

1. SELECT DISTINCT o.emp_reviewer_id AS employee_id
   FROM Orders AS o
   UNION ALL
   SELECT DISTINCT o.emp_order_creation_id AS employee_id
   FROM Orders AS o
   UNION ALL
   SELECT e.employee_id
   FROM Employee AS e

[Emma_Fromm]

Time to Complete: 10 minutes
Rating: Beginner

1. Query 1 Solution:
   SELECT first_name, last_name, employee_email AS email
   FROM Employee
   UNION
   SELECT first_name, last_name, email
   FROM Vendor;
2. Query 2 Solution:
   SELECT *
   FROM Inventory
   UNION
   SELECT *
   FROM New_Inventory;
3. Query 3 Solution:
   SELECT DISTINCT emp_reviewer_id AS employee_id
   FROM Orders
   UNION ALL
   SELECT DISTINCT emp_order_creation_id AS employee_id
   FROM Orders
   UNION ALL
   SELECT employee_id
   FROM Employee;

[Adeline_Christensen]

Time to complete: 10 minutes
Difficulty: Beginner

1. SELECT first_name, last_name, employee_email AS email
   FROM Employee
   UNION
   SELECT first_name, last_name, email
   FROM Vendor

2. SELECT *
   FROM New_Inventory
   UNION
   SELECT *
   FROM Inventory

SELECT Distinct emp_reviewer_id As employee_id
From Orders
UNION ALL
SELECT DISTINCT emp_order_creation_id AS employee_id
FROM Orders
UNION ALL
SELECT employee_id
From Employee

[Jared_Divelbiss]

Time: 15
Difficulty: Beginner
Solution:

SELECT first_name, last_name, employee_email AS email
FROM Employee
UNION
SELECT first_name, last_name, email
FROM VENDOR;

SELECT *
FROM New_Inventory
UNION
SELECT *
FROM Inventory;

SELECT DISTINCT emp_reviewer_id AS employee_id
FROM Orders
UNION ALL
SELECT DISTINCT emp_order_creation_id AS employee_id
FROM Orders
UNION ALL
SELECT employee_id
FROM Employee;

[Collin_Simon]

Time to complete: 10 minutes
Difficulty: Easy
Great review of material covered last week

SELECT first_name, last_name, employee_email AS email
From Employee
UNION
Select first_name, last_name, email
From Vendor;

Select *
From Inventory
UNION
SELECT *
From New_Inventory;

Select DISTINCT emp_reviewer_id as employee_id
From Orders;
Union ALL
Select Distinct emp_order_creation_id as employee_id
From Employee
Union ALL
Select employee_id
From Orders;

[Colter_Sill]

Time to Complete: 15 mins
Difficulty: Beginner
Solutions:
1.SELECT first_name, last_name, employee_email AS email
FROM Employee
Union
SELECT first_name, last_name, email
FROM Vendor;
2.SELECT*
FROM Inventory
UNION
SELECT*
FROM New_Inventory;
3.SELECT DISTINCT emp_reviewer_id AS employee_id
FROM Orders
UNION ALL
SELECT DISTINCT emp_order_creation_id AS employee_id
FROM Orders
UNION ALL
SELECT employee_id
FROM Employee ;

[Kameron_K_Sakamoto]

Time to Complete: 10min
Difficulty: Beginner
Solution:
Q1:

SELECT first_name, last_name, employee_email AS email
FROM Employee
UNION
SELECT first_name, last_name, email
FROM Vendor;

Q2:

SELECT *
FROM New_Inventory
UNION
SELECT*
FROM Inventory;

Q3:

SELECT DISTINCT emp_reviewer_id AS employee_id
FROM Orders
UNION ALL
SELECT DISTINCT emp_order_creation_id AS employee_id
FROM Orders
UNION ALL
SELECT employee_id
FROM Employee;

[Sophie_Dong]

Time to Complete: 10 minutes
Difficulty: Easy
Solution: See Below
1:
SELECT first_name, last_name, employee_email AS email
FROM Employee
UNION
SELECT first_name, last_name, email
FROM Vendor;
2:
SELECT *
FROM New_Inventory
UNION
SELECT *
FROM Inventory;
3:
SELECT DISTINCT emp_reviewer_id AS employee_id
FROM Orders
UNION ALL
SELECT DISTINCT emp_order_creation_id AS employee_id
FROM Orders
UNION ALL
SELECT employee_id
FROM Employee;

[Genevieve_Nichols]

Q1: SELECT [first_name], [last_name], [empoyee_email] AS email
FROM Employee
UNION SELECT [first_name], [last_name], [email]
FROM Vendor;

Q2: SELECT *
FROM New_Inventory
UNION SELECT *
FROM Inventory;

Q3: SELECT DISTINCT emp_reviewer_id AS employee_id
FROM Orders
UNION ALL
SELECT DISTINCT emp_order_creation_id AS employee_id
FROM Orders
UNION ALL SELECT employee_id
FROM Employee;

[Sydney_Clove]

1. SELECT first_name, last_name, employee_email AS email
   FROM Employee
   UNION
   SELECT first_name, last_name, email
   FROM Vendor
2. SELECT *
   FROM New_Inventory
   UNION
   SELECT *
   FROM Inventory
3. SELECT DISTINCT emp_reviewer_id AS employee_id
   FROM Orders
   UNION ALL
   SELECT employee_id
   FROM Employee
   UNION ALL
   SELECT DISTINCT emp_order_creation_id AS employee_id
   FROM Orders;

[Thomas_Sanders]

Time to complete: 14 minutes
Difficulty: Easy
Solutions:
Q1: SELECT first_name, last_name, employee_email as “email”
From Employee
Union
SELECT first_name, last_name, email
From Vendor;

Q2: SELECT *
From New_Inventory
UNION
SELECT *
From Inventory;

Q3: SELECT DISTINCT emp_reviewer_id as “employee_id”
From Orders
Union ALL
SELECT DISTINCT emp_order_creation_id as “employee_id”
From Orders
Union ALL
SELECT employee_id
From Employee;

[Lindsay_Shields]

Time to complete: 10 minutes
Difficulty: Easy

Q1:
SELECT first_name, last_name, employee_email AS email
FROM Employee
UNION
SELECT first_name, last_name, email
FROM Vendor;

Q2:
SELECT *
FROM New_Inventory
UNION
SELECT *
FROM Inventory;

Q3:
SELECT DISTINCT emp_reviewer_id AS employee_id
FROM Orders
UNION ALL
SELECT DISTINCT emp_order_creation_id AS employee_id
FROM Orders
UNION ALL
SELECT employee_id
FROM Employee;

[Carter_McQuivey]

Time: 20 minutes
Difficulty: medium
Solution:

Q1:
SELECT Employee.first_name, Employee.last_name, Employee.employee_email AS email
FROM Employee

Q2:
SELECT*
FROM New_Inventory
UNION
SELECT*
FROM Inventory;

Q3:
SELECT DISTINCT Orders.emp_reviewer_id AS employee_id
FROM Orders
UNION ALL
SELECT DISTINCT Orders.emp_order_creation_id AS employee_id
FROM Orders
UNION ALL
SELECT Employee.employee_id
FROM Employee;

[Andrew_Benson]

Time to Complete: 15 Minutes
Difficulty: Easy
Solutions:
1.
SELECT first_name, last_name, employee_email AS email
FROM Employee
UNION
SELECT first_name, last_name, email
FROM Vendor

SELECT *
FROM New_Inventory
UNION
SELECT *
FROM Inventory

SELECT DISTINCT emp_reviewer_id AS employee_id
FROM Orders
UNION ALL
SELECT DISTINCT emp_order_creation_id as employee_id
FROM Orders
UNION ALL
SELECT DISTINCT employee_id
FROM Employee
ORDER BY employee_id

[Nolan_Ward]

Time: 15 min
Difficulty: Easy

Q1: SELECT first_name, last_name, employee_email as email
FROM Employee
Union
SELECT first_name, last_name, email
FROM Vendor

Q2. SELECT *
FROM Inventory
UNION
SELECT *
FROM New_Inventory

Q3. SELECT DISTINCT emp_reviewer_id AS employee_id
FROM Orders
UNION ALL
SELECT DISTINCT emp_order_creation_id AS employee_id
FROM Orders
UNION ALL
SELECT employee_id
FROM Employee;

[Liam_Smith]

SELECT e.first_name, e.last_name, e.employee_email AS email;
FROM Employee AS e
UNION
SELECT v.first_name, v.last_name, v.email;
FROM Vendor AS v

2. SELECT *
   FROM Inventory
   UNION
   SELECT *
   FROM New_Inventory

SELECT DISTINCT o.emp_reviewer_id AS employee_id,
FROM Orders AS o
UNION ALL
SELECT DISTINCT o,emp_order_creation_id AS employee_id
FROM Orders AS o
UNION ALL
SELECT e.employee_id
FROM Employee AS e

[Moa_Redford]

SELECT first_name, last_name, employee_email AS “email”
FROM Employee
UNION
SELECT first_name, last_name, email
FROM Vendor ;

SELECT *
FROM New_Inventory
UNION
SELECT *
FROM Inventory ;

SELECT DISTINCT emp_reviewer_id AS “emploiyee_id”
FROM Order
UNION ALL
SELECT DISTINCT emp_reviewer_id AS “emploiyee_id”
FROM Order
UNION ALL
SELECT employee_iud
FROM Employee ;