177|SQL – Intro to Join Statements

[William_Cole]

Time to complete: 20
Difficulty: Between Easy and Intermediate

1. SELECT order_id, employee.first_name, employee.last_name
   FROM Orders INNER Join Employee ON Orders.emp_order_creation_id = Employee.employee_id
2. SELECT company_name, inventory_name, std_order_qty
   FROM Inventory LEFT JOIN Vendor on inventory.preferred_vendor = vendor.vendor_id
3. SELECT order_id, payable_amount
   FROM Invoice
4. SELECT order_id, payable_amount
   FROM Invoice

[Kate_Munger]

Time to complete: 10 minutes
Difficulty: Beginner

SELECT o.order_id, e.first_name, e.last_name
FROM Orders AS o
INNER JOIN Employee AS e ON o.emp_order_creation = e.employee_id;

SELECT v.company_name, i.inventory_name, i.std_order_qty
FROM Inventory AS i
INNER JOIN Vendor AS v ON i.preferred_vendor = v.vendor_id;

SELECT order_id, payable_amount
FROM Invoice;

SELECT i.inventory_name, v.company_name, inv.emp_received_id, inv.invoice_receipt_date
FROM (Inventory AS i INNER JOIN Vendor AS v ON i.preferred_vendor = v.vendor_id)
INNER JOIN Invoice AS inv ON v.vendor_id = inv.vendor_id;

[Austin_Smith]

1. SELECT o.order_id, e.first_name, e.last_name
   FROM Orders AS o INNER JOIN Employee AS e ON o.emp_order_creation = e.Employee_ID;
2. SELECT company_name, inventory_name, std_order_qty
   From Inventory i
   Inner Join vendor v on v.vendor_id = i.preferred_vendor
3. SELECT order_id, payable_amount
   From invoice
4. SELECT i.inventory_name, v.company_name, iv.emp_received_id, iv.invoice_receipt_date
   From (inventory as i INNER JOIN Vendor v on i.preferred_vendor = v.vendor_id)
   Inner Join invoice iv on v.vendor_id = iv.vendor_id

[Spencer_McArthur]

Time to complete: 13 mins
Rating: Easy
Solution:

q1:
Select order_id, first_name, last_name

FROM Employee

Inner join Orders on Orders.emp_order_creation_id=Employee.Employee_ID;

q2:
SELECT company_name, inventory_name, std_order_qty

From inventory

inner join vendor on inventory.preferred_vendor=vendor.vendor_id;

q3:
SELECT order_id, payable_amount
FROM invoice

q4:
SELECT inventory.inventory_name, vendor.company_name, invoice.emp_received_id, invoice.invoice_receipt_date

FROM (inventory

Inner JOIN vendor on inventory.preferred_vendor=vendor.vendor_id)

INNER JOIN invoice on vendor.vendor_id=invoice.vendor_id;

[Zen_Villondo]

Time to complete: 30 minutes
Difficulty: Intermediate
Notes: my syntax with the () for the first join was off
Q1
SELECT order_id, first_name, last_name

FROM Orders

INNER JOIN Employee ON Orders.emp_order_creation_id=Employee.Employee_ID

Q2
SELECT company_name, inventory_name, std_order_qty
FROM Inventory
INNER JOIN Vendor ON inventory.preferred_vendor=vendor.vendor_id

Q3
SELECT order_id, payable_amount
FROM Invoice

Q4
SELECT inventory_name, company_name, emp_received_id, invoice_receipt_date

FROM (Vendor INNER JOIN Inventory ON Vendor.Vendor_id = Inventory.preferred_vendor)

INNER JOIN Invoice ON Vendor.Vendor_id = Invoice.vendor_id

[Cady_Eaton]

Difficulty-Intermediate
Time-25 mins
Solutions:
Q1
SELECT
Orders.order_id,
Employee.first_name,
Employee.last_name
FROM
Orders
INNER JOIN
Employee
ON
Orders.emp_order_creation_id = Employee.employee_id;
Q2
SELECT v.company_name, i.inventory_name, i.std_order_qty
FROM Inventory AS i
LEFT JOIN Vendor AS v ON i.preferred_vendor=v.vendor_id
Q3
SELECT order_id, payable_amount
FROM Invoice
Q4
SELECT
inventory_name,
company_name,
emp_received_id,
invoice_receipt_date
FROM
(Inventory
INNER JOIN Vendor ON Inventory.preferred_vendor = Vendor.vendor_id)
INNER JOIN Invoice ON Vendor.vendor_id = Invoice.vendor_id;

[Tyler_Herget]

Time to complete: 15 min
Rating: Moderate
Solution:

1. SELECT order_id, first_name, last_name
   From orders
   Inner Join Employee ON Orders.emp_order_creation_id=Employee.Employee_ID
2. SELECT company_name, inventory_name, std_order_qty
   From Inventory
   Inner Join Vendor ON Inventory.preferred_vendor = Vendor.vendor_id
3. SELECT order_id, payable_amount
   From Invoice
4. SELECT inventory_name, company_name, emp_received_id, invoice_receipt_date
   From (Inventory INNER JOIN Vendor ON Vendor.vendor_id=Inventory.preferred_vendor)
   INNER JOIN Invoice ON Invoice.vendor_id=Vendor.vendor_id;

[Justin_Day]

Time to complete: 10 minutes
Difficulty: Easy

SELECT o.order_id, e.first_name, e.last_name
FROM Orders o
INNER JOIN Employee e ON o.emp_order_creation_id = e.employee_id

SELECT v.company_name, i.inventory_name, i.std_order_qty
FROM Vendor v
INNER JOIN Inventory i ON v.vendor_id = i.preferred_vendor;

SELECT order_id, payable_amount
FROM Invoice;

SELECT i.inventory_name, v.company_name, a.emp_received_id, a.invoice_receipt_date
FROM (Inventory i
INNER JOIN Vendor v ON i.preferred_vendor = v.vendor_id)
INNER JOIN Invoice a ON v.vendor_id = a.vendor_id;

[Cragun_Bastian]

Time to complete: 30 min
Difficulty: Intermediate

1. SELECT Orders.order_id, Employee.first_name, Employee.last_name
   FROM Orders INNER JOIN Employee ON Orders.emp_order_creation_id=Employee.employee_id;

2. SELECT company_name, inventory_name, std_order_qty
   FROM Inventory
   INNER JOIN Vendor ON Inventory.preferred_vendor=Vendor.vendor_id;

3. SELECT order_id, payable_amount
   FROM Invoice;

4. SELECT inventory_name, company_name, emp_received_id, invoice_receipt_date
   FROM (Inventory
   INNER JOIN Vendor ON Inventory.preferred_vendor=Vendor.vendor_id)
   INNER JOIN Invoice ON Vendor.vendor_id=Invoice.vendor_id;

[Ethan_Benoit]

Time to complete 15 minutes
Difficulty: Beginner
See Solution Below:
1:
SELECT o.order_id, e.first_name, e.last_name
From Orders o
Inner Join Employee e on o.emp_order_creation_id = e.employee_id;
2:
SELECT v.company_name, i.inventory_name, i.std_order_qty
From vendor v
Inner Join inventory i on i.preferred_vendor = v.vendor_id;
3:
SELECT order_id, payable_amount
From invoice;
4:
SELECT i.inventory_name, v.company_name, inv.emp_received_id, inv.invoice_receipt_date

From (Inventory as i inner join vendor as v on i.preferred_vendor = v.vendor_id )

Inner Join invoice as inv on v.vendor_id = inv.vendor_id;

[Eison_Deng]

Time to Complete: 20 minutes
Difficulty: Easy
Solution:

1.SELECT o.order_id, e.first_name, e.last_name
FROM Orders AS o
INNER JOIN Employee AS e ON o.emp_order_creation_id = e.Employee_id;

2.SELECT v.company_name, i.inventory_name, i.std_order_qty
FROM Vendor AS v
INNER JOIN Inventory AS i ON i.preferred_vendor=v.vendor_id

3.SELECT order_id, payable_amount
FROM Invoice;

4.SELECT i.inventory_name, v.company_name, inv.emp_received_id, inv.invoice_receipt_date
FROM (Inventory AS i INNER JOIN Vendor AS v ON i.preferred_vendor=v.vendor_id)
INNER JOIN Invoice AS inv ON inv.vendor_id=v.vendor_id;

[Nick_Price]

Time to complete: 30 minutes
Difficulty: Intermediate

1. SELECT o.order_id, e.first_name, e.last_name
   FROM Orders o INNER JOIN Employee e ON o.emp_order_creation_id = e.employee_id;

2. SELECT v.company_name, i.inventory_name, i.std_order_qty
   FROM Inventory i
   LEFT JOIN Vendor v ON i.preferred_vendor=v.vendor_id;

3. SELECT order_id, payable_amount
   FROM Invoice;

4. SELECT inven.inventory_name, v.company_name, inv.emp_received_id, inv.invoice_receipt_date
   FROM ( Inventory inven INNER JOIN Vendor v ON inven.preferred_vendor = v.vendor_id)
   INNER JOIN Invoice inv ON v.vendor_id = inv.vendor_id;

[Audrey_Vengesai]

Time to complete: 30 minutes
Difficulty: Moderate
Solutions:

1. SELECT
   Orders.order_id,
   Employee.first_name,
   Employee.last_name
   FROM Orders
   INNER JOIN Employee ON Orders.emp_order_creation_id = Employee.Employee_ID;
2. SELECT vendor.company_name, inventory.inventory_name, inventory.std_order_qty
   FROM inventory
   INNER JOIN vendor ON inventory.preferred_vendor= vendor.vendor_id ;
3. SELECT order_id, payable_amount
   FROM Invoice
4. SELECT inventory.inventory_name, vendor.company_name, invoice.emp_received_id, invoice.invoice_receipt_date
   FROM ((inventory
   INNER JOIN vendor ON inventory.preferred_vendor=vendor.vendor_id )
   INNER JOIN invoice ON vendor.vendor_id=invoice.vendor_id);

[Josue_Quilantan]

Time to complete: 15 minutes
Difficulty: Beginner
Solution:

SELECT o.order_id, e.first_name, e.last_name
FROM Orders o
INNER JOIN Employee e ON o.emp_order_creation_id=e.employee_id;

SELECT v.company_name, i.inventory_name, i.std_order_qty
FROM Inventory i
INNER JOIN Vendor v ON i.preferred_vendor=v.vendor_id;

SELECT order_id, payable_amount
FROM Invoice;

SELECT i.inventory_name, v.company_name, iv.emp_received_id, iv.invoice_receipt_date
FROM (Inventory i
INNER JOIN Vendor v ON i.preferred_vendor=v.vendor_id)
INNER JOIN Invoice iv ON v.vendor_id=iv.vendor_id;

[Finlay_Lofthouse]

Time: 10 min
Difficulty: Easy
Solutions:
Q1
SELECT o.order_id, e.first_name, e.last_name

FROM Orders AS o

INNER JOIN Employee AS e on o.emp_order_creation_id = e.employee_id;
Q2
SELECT v.company_name, i.inventory_name, i.std_order_qty

FROM Vendor AS v

INNER JOIN Inventory AS i ON v.vendor_id = i.preferred_vendor;
Q3
SELECT o.order_id, i.payable_amount

FROM (Orders AS o

INNER JOIN Vendor AS v ON o.vendor_id = v.vendor_id)

INNER JOIN Invoice AS i ON v.vendor_id = i.vendor_id;
Q4
SELECT i.inventory_name, v.company_name, inv.emp_received_id, inv.invoice_receipt_date

FROM (Inventory AS i INNER JOIN Vendor AS v on i.preferred_vendor = v.vendor_id)

INNER JOIN Invoice AS inv ON v.vendor_id = inv.vendor_id;

[Braden_Jones]

Time complete: 20 mins
Difficulty: Medium
Solution:

1. SELECT o.order_id, e.first_name, e.last_name
   FROM Orders AS o
   INNER JOIN Employee AS e ON o.emp_order_creation_id= e.Employee_id
   ORDER BY o.order_id;

2. SELECT v.company_name, i.inventory_name, i.std_order_qty
   FROM Inventory AS i
   INNER JOIN Vendor AS v ON v.vendor_id = i.preferred_vendor;

3. SELECT order_id, payable_amount
   FROM Invoice;

4. SELECT inv.inventory_name, v.company_name, i.emp_received_id, i.invoice_receipt_date
   FROM (Vendor AS v
   INNER JOIN Inventory AS inv ON inv.preferred_vendor = v.vendor_id)
   INNER JOIN Invoice AS i ON i.vendor_id = v.vendor_id;

[Elisabeth_Ware]

Time to Complete: 15 minutes
Difficulty: Easy

Solutions:

1. SELECT orders.order_id, employee.first_name, employee.last_name
   FROM ORDERS
   LEFT JOIN Employee ON orders.emp_order_creation_id=employee.employee_ID
2. SELECT v.company_name, I.inventory_name, I.std_order_qty
   FROM Inventory I
   INNER JOIN Vendor v ON v.vendor_id=I.preferred_vendor;
3. SELECT order_id, payable_amount
   FROM Invoice;
4. SELECT i.inventory_name, v.company_name, invoice.emp_received_id, inv.invoice_receipt_date
   FROM ((Inventory i INNER JOIN Vendor v ON i.preferred_vendor=v.vendor_id) INNER JOIN Invoice inv ON v.vendor_id=inv.vendor_id);

[Joshua_Folau]

Time to complete: 20 minutes
Difficulty: Intermediate

Q1:
SELECT o.order_id, e.first_name, e.last_name
FROM Orders o
INNER JOIN Employee e ON o.emp_order_creation_id = e.employee_id;

Q2:
SELECT v.company_name, i.inventory_name, i.std_order_qty
FROM Inventory i
INNER JOIN Vendor v ON i.preferred_vendor = v.vendor_id;

Q3:
SELECT order_id, payable_amount
FROM Invoice;

Q4:
SELECT inventory_name, company_name, emp_received_id, invoice_receipt_date
FROM (Inventory INNER JOIN Vendor ON Inventory.preferred_vendor = Vendor.vendor_id)
INNER JOIN Invoice ON Vendor.vendor_id = Invoice.vendor_id;

[Annecy_Hansen]

Time to Complete: 15
Rating: Intermediate
Notes: Interesting to use the join clauses

SELECT o.order_id, e.first_name, e.last_name
FROM Orders AS o
INNER JOIN Employee AS e
ON o.emp_order_creation_id = e.Employee_ID;

SELECT v.company_name, i.inventory_name, i.std_order_qty
FROM Inventory as i
LEFT JOIN Vendor as v ON i.preferred_vendor = v.vendor_id;

SELECT order_id, payable_amount
FROM Invoice;

SELECT i.inventory_name, v.company_name, inv.emp_received_id, inv.invoice_receipt_date
FROM Inventory AS i
INNER JOIN Vendor AS v ON i.preferred_vendor = v.vendor_id
INNER JOIN Invoice AS inv ON v.vendor_id = inv.vendor_id;

[Alejandro_Sanchez]

Time to complete: 30 Minutes
Difficulty: Intermediate
Solution:
1
SELECT Orders.order_id, Employee.first_name, Employee.last_name
FROM Orders
INNER JOIN Employee ON Orders.emp_order_creation_id=Employee.Employee_ID;
2
SELECT Vendor.company_name, Inventory.inventory_name, Inventory.std_order_qty
FROM Vendor
INNER JOIN Inventory ON Vendor.vendor_id=inventory.preferred_vendor;
3
SELECT order_id, payable_amount
FROM Invoice;
4
SELECT inventory_name, company_name, emp_recieved_id, invoice_receipt_date
FROM (Inventory
INNER JOIN Vendor ON Inventory.preferred_vendor=Vendor.vendor_id)
INNER JOIN Invoice ON Vendor.vendor_id=Invoice.vendor_id;