178|SQL – Unions with Precision

[James_Lloyd]

Time to complete: 10 mins
Difficulty: Easy
Solutions: →

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

[Jackson_Bond]

Time to complete: 10
Level of 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 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;

[Elizabeth_Bisel]

Time to complete: 20 min
Difficulty: medium

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;

[Alejandro_Sanchez]

Time to complete: 8 Minutes
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;

[jacksonbutler10]

Time to Complete: 15 minutes
Difficulty: Easy-Medium
Solution: See Below

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

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

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

[Anela_Zamarron]

Query 1
Select first_name,last_name, employee_email as email
From employee

Union all

Select first_name, last_name, email
From Vendor;

Query 2
Select *
From Inventory
union
Select*
From New_Inventory;

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

[Coleman_Halls]

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

[Zachary_Kuta]

Time to complete: 8 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;

[Mackay_Roberts]

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;

[Elizabeth_Brown]

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

[Cannon_Harmer]

Time 15 min
Rating: 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;

[Claire_Walters]

Q1. 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
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

[Jane_Cai]

Time to Complete: 10 minutes
Rating: Beginning
Comment: Simple challenge to remember UNION and UNION ALL

Solution
Q1:
SELECT first_name, last_name, employee_email AS email

FROM Employee

UNION

SELECT first_name, last_name, email

FROM Vendor;
Q2:
SELECT DISTINCT emp_received_id AS employee_id

FROM Orders

UNION ALL

SELECT DISTINCT emp_order_creation_id

FROM Orders

UNION ALL

SELECT employee_id

FROM Employee;
Q3:
SELECT DISTINCT emp_received_id AS employee_id

FROM Orders

UNION ALL

SELECT DISTINCT emp_order_creation_id

FROM Orders

UNION ALL

SELECT employee_id

FROM Employee;

[Yoomin_Jang]

Time to complete: 15 mins
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.employee_id
   FROM Employee;

[Cady_Eaton]

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

[Ava_Egan]

Time to complete: 15 minutes
Difficulty: Intermediate
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;

[Layton_Allred]

Time to Complete: 10 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
   FROM vendor as 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;

[Emma_Hooper]

Time: 10 Minutes
Rating: Easy
Solution:

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 employee_id
FROM Employee
UNION ALL
SELECT DITINCT emp_order_creation_id AS employee_id
FROM Orders;

[Kaden_Westerlind]

Time to complete 7 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 AS employee_id
   FROM Orders
   UNION ALL
   Select employee_id
   from employee ;

[Meg_Nielsen]

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