178|SQL – Unions with Precision

[Gavin_Ross]

Time to complete: 10 mins
Difficulty: Beginner
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;

[Aaron_Greenwood]

Time to complete: 10 mins
Difficulty: Easy
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 employee_id
FROM Employee
UNION ALL
SELECT DISTINCT emp_reviewer_id AS employee_id
FROM Orders
UNION ALL
SELECT DISTINCT emp_order_creation_id AS employee_id
FROM Orders;

[Nate_Hansen]

Time to complete: 20 min
Difficulty: Medium
Comments:

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;

[Faith_Bangerter]

Time to Complete: 15 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;

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;

[Ian_Bonine]

Time: 15 mins
difficulty: intermediate

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;

[Connor_Smith]

Time to Complete: 15 minutes
Difficulty: Easy

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;

[Andrew_Wells]

Time to complete: 15 min
Rating: Easy
Solutions:
1.
SELECT first_name, last_name, employee_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;

[Rachel_Lopez]

Time to Complete: 10 minutes
Rating: Easy
Comments: hard to find the New Inventory table but a good review

Q1: SELECT first_name, last_name
from Employee
UNION select first_name, last_name
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
from orders
UNION ALL select employee_id
from Employee;

[Katie_Kim]

Time to complete: 15 minutes
Difficulty: Medium
Solution:

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

[Katelyn_Hamilton]

Time to complete: 25 minutes
Difficulty: Easy
Solution:

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

[Lilia_Fisher]

Time to Complete: 15 minutes
Difficulty: Intermediate

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;

[Tyson_Yee]

Time to Complete: 15 minutes
Rating: 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 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;

[Molly_Pratt]

Time to complete: 15 minutes
Difficulty: Easy
Solution:

1: 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 as email
FROM Vendor as v;

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;

[Chris_Sosa]

Time to complete: 10 minutes
Difficulty: Beginner
Notes: Great practice!

1. 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 New_Inventory
   UNION
   SELECT *
   FROM 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;

[Hailey_Smith]

Time: 15 minutes
Difficulty: Easy

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

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;

[Preston_Dudley]

Time to Complete: 7 minutes
Difficulty: Easy
Solution: See Below
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
FROM Orders
UNION ALL
SELECT employee_id
FROM employee;

[Charlotte_Owsley]

Time to complete 20 minutes
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 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
;

[Kate_Munger]

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;
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;

[Austin_Smith]

1. SELECT first_name, last_name, employee_email as email
   from employee
   Union
   Select first_name, last_name, email
   from vendor
2. SELECT first_name, last_name, employee_email as email
   from employee
   Union
   Select first_name, last_name, email
   from vendor
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

[Spencer_McArthur]

TTC: 13
Ranking: easy
Notes:

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 DISTINCT employee_id FROM Employee;