177|SQL – Intro to Join Statements

Morgan_Woodland · February 26, 2025, 7:56pm

Time to complete: 12
Rating: Easy
Solutions:
1.
SELECT Orders.order_id, Employee.first_name, Employee.last_name
FROM Orders
INNER JOIN Employee ON Orders.emp_order_creation_id = Employee.emplyee_id;
2.
SELECT v.company_name, i.inventoryname, i.std_order_qty
FROM Vendor AS v
LEFT 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.preffered_vendor = v.vendor_id)
INNER JOIN Invoice AS inv ON v.vendor_id = inv.vendor_id);

Aidan_Greenwade · February 26, 2025, 8:16pm

Time to Complete: 10 minutes
Difficulty: Easy
Solution: See Below
1)
Select order_id, first_name, last_name
From (orderdetails, Inner join orders on orderdetails.order_id = orders.order_id) inner join employee on orders.employee_id = employee.employee_id
2)
Select company_name, inventory_name, std_order_qty
From inventory, inner join vendor on inventory.preffered_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.preffered_vendor = vendor.vendor_id) inner join invoice on vendor.vendor_id = invoice.vendor_id

Tate_Erickson · February 26, 2025, 8:21pm

Time: 15 minutes
Rating: Beginner

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

Question 2:
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;

Question 3:
SELECT order_id, payable_amount
FROM Invoice

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

Travis_Walker · February 26, 2025, 8:30pm

SELECT company_name, inventory_name, std_order_qty
FROM Inventory AS i INNER JOIN Vendor AS v ON i.preferred_vendor = v.vendor_id;
2.SELECT company_name, inventory_id, std_order_qty
FROM Inventory i
INNER JOIN Vendor v on i.preferred_vendor = v.vendor_id
3.SELECT order_id, sum(qty_ordered * price_per_unit) as payable_amount
FROM OrderDetail
GROUP BY order_id
4.SELECT i.inventory_name, v.company_name, inv.emp_received_id, inv.invoice_receipt_date
FROM (Vendor v
INNER JOIN Inventory i ON v.vendor_id = i.preferred_vendor)
INNER JOIN Invoice inv ON v.vendor_id = inv.vendor_id;

Benton_Worthen · February 26, 2025, 8:58pm

Time to Complete: 20 min
Difficulty: Intermediate

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 v.vendor_id=i.preferred_vendor;
SELECT o.order_id, i.payable_amount
FROM (Orders AS o
INNER JOIN OrderDetail AS od ON o.order_id = od.order_id)
INNER JOIN Invoice AS i ON o.order_id = i.order_id;
SELECT i.inventory_name, v.company_name, inv.emp_received_id, inv.invoice_receipt_date
FROM (Invoice as inv
Inner Join vendor v on inv.vendor_id=v.vendor_id)
inner join inventory i on v.vendor_id=i.preferred_vendor;

Lainey_Jackson · February 26, 2025, 9:00pm

Time to complete: 15 minutes
Difficulty: Beginner
1.
SELECT o.order_ID, e.first_name, e.last_name
FROM Orders AS o
LEFT 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 v.vendor_id=i.preferred_vendor;

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

Michelle_Black · February 26, 2025, 9:05pm

SELECT
Orders.order_id,
Employee.first_name,
Employee.last_name
FROM Orders
JOIN Employee
ON Orders.emp_order_creation_id = Employee.Employee_ID;
SELECT
v.company_name,
i.inventory_name,
i.std_order_qty
FROM Inventory i
JOIN Vendor v
ON i.preferred_vendor = v.vendor_id;
SELECT order_id, payable_amount
FROM Invoice;
SELECT i.inventory_name, v.company_name, in.emp_reveived_id, in.invoice_receipt_date
FROM ((Inventory i INNER JOIN Vendor v ON i.preferred_vendor = v.vendor_id) INNER JOIN Invoice in ON v.vendor_id=in.vendor_id);

Seth_Davis · February 26, 2025, 9:11pm

Time to Complete: 30 mins
Difficulty: Intermediate

SELECT Orders.order_id, Employee.first_name, Employee.last_name

FROM Orders

Inner JOIN Employee On Orders.emp_order_creation_id = Employee.employee_id;

SELECT vendor.company_name, inventory.inventory_name, inventory.std_order_qty

FROM Inventory

LEFT JOIN Vendor on Inventory.preferred_vendor = Vendor.vendor_id

SELECT order_id, payable_amount

FROM Invoice;

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

Rachel_Hale · February 26, 2025, 9:13pm

Time to complete: 15 minutes
Difficulty: Easy

Query 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
Query 2:
SELECT Vendor.company_name, Inventory.inventory_name, Inventory.std_order_qty
FROM Inventory
LEFT JOIN Vendor ON Inventory.preferred_vendor=Vendor.vendor_id
Query 3:
SELECT order_id, payable_amount
FROM Invoice
Query 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

Kambrie_Earl · February 26, 2025, 9:32pm

Time to complete: 10 minutes
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 v.company_name, i.inventory_name, i.std_order_qty
FROM Vendor v
LEFT JOIN Inventory i ON i.preferred_vendor = v.vendor_id;
3:
SELECT i.order_id, i.payable_amount
FROM Invoice i;
4:
SELECT Inventory.inventory_name, Vendor.company_name, Invoice.emp_received_id, invoice_receipt_date
FROM (Vendor
INNER JOIN Inventory ON Inventory.preferred_vendor = Vendor.vendor_id)
INNER JOIN Invoice ON Invoice.vendor_id = Vendor.vendor_id;

Luke_Robinson · February 26, 2025, 9:44pm

Time to Complete: 30 minutes
Difficulty: Intermediate

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

SELECT Vendor.company_name, Inventory.inventory_name, Inventory.std_order_qty
FROM Inventory
LEFT JOIN Vendor ON Inventory.preferred_vendor = Vendor.vendor_id

SELECT order_id, payable_amount
FROM Invoice

SELECT
Inventory.inventory_name,
Vendor.company_name,
Invoice.emp_received_id,
Invoice.invoice_receieved_date

FROM
Inventory
INNER JOIN Vendor ON Vendor.vendor_id = Inventory.preferred_vendor
INNER JOIN Invoice ON Vendor.vendor_id = Invoice.vendor_id

Harrison_Briggs · February 26, 2025, 9:49pm

Time to Complete: 15 min
Difficulty: Beginner
Solution:
1.
SELECT Orders.order_id, Employee.first_name, Employee.last_name
FROM Employee
INNER JOIN Orders on Orders.emp_order_creation_id=Employee.Employee_ID;

SELECT Vendor.Company_name, Inventory.Inventory_name, Inventory.std_order_qty
FROM Vendor
RIGHT JOIN Inventory ON Inventory.preferred_vendor=Vendor.Vendor_id;

SELECT order_id, payable_amount
FROM Invoice;

SELECT Inventory.inventory_name, vendor.company_name, invoice.emp_received_id, invoice.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;

Jared_Davis · February 26, 2025, 9:51pm

Time to complete: 30 minutes
Difficulty: Medium

SELECT
Orders.order_id,
Employee.first_name,
Employee.last_name
FROM
Orders
JOIN
Employee
ON
Orders.emp_order_creation_id = Employee.employee_id;
SELECT
Vendor.company_name,
Inventory.inventory_name,
Inventory.std_order_qty
FROM
Inventory
JOIN
Vendor
ON
Inventory.preferred_vendor = Vendor.vendor_id;
SELECT
Orders.order_id,
SUM(OrderDetail.qty_ordered * OrderDetail.price_per_unit) AS payable_amount
FROM
Orders
JOIN
OrderDetail
ON
Orders.order_id = OrderDetail.order_id
GROUP BY
Orders.order_id;
SELECT
Inventory.inventory_name,
Vendor.company_name,
Invoice.emp_received_id,
Invoice.invoice_date AS invoice_receipt_date
FROM
Invoice
JOIN
Inventory
ON
Invoice.vendor_id = Inventory.preferred_vendor
JOIN
Vendor
ON
Inventory.preferred_vendor = Vendor.vendor_id;

Detroit_Kane · February 26, 2025, 9:57pm

Time to Complete 15 minutes
Difficulty: Intermediate

Solutions:

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 v.vendor_ID = i.Preferred_vendor)
INNER JOIN Invoice IV on IV.Vendor_ID = v.Vendor_ID;

Hazel_Bell · February 26, 2025, 9:59pm

Time to complete: 10 min
Difficulty: Intermediate
Solution:

SELECT
Orders.order_id,
Employee.first_name,
Employee.last_name
FROM Orders
JOIN Employee ON Orders.emp_order_creation_id = Employee.Employee_ID;
SELECT
Vendor.company_name,
Inventory.inventory_name,
Inventory.std_order_qty
FROM Inventory
JOIN Vendor ON Inventory.preferred_vendor_id = Vendor.vendor_id;
SELECT order_id, payable_amount
FROM Invoice;
SELECT
Inventory.inventory_name,
Vendor.company_name,
Invoice.emp_received_id,
Invoice.invoice_receipt_date
FROM Invoice
JOIN Inventory ON Invoice.inventory_id = Inventory.inventory_id
JOIN Vendor ON Inventory.preferred_vendor_id = Vendor.vendor_id;

Easton_Edwards · February 26, 2025, 10:01pm

Time: 10 minutes
Difficulty: Easy
Solution:

SELECT Orders.order_id, Employee.first_name, Employee.last_name
FROM Orders
INNER JOIN Employee ON Orders.emp_order_creation_id = Employee.Employee_ID;
SELECT Vendor.company_name, Inventory.inventory_name, Inventory.std_order_qty
FROM Vendor
INNER JOIN Inventory ON Vendor.vendor_id = Inventory.preferred_vendor;
SELECT order_id, payable_amount
FROM Invoice;
SELECT Inventory.inventory_name, Vendor.company_name, Invoice.emp_received_id, Invoice.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;

McKay_Larsen · February 26, 2025, 10:06pm

Q1:

SELECT order_id, first_name, last_name

FROM Employee INNER JOIN Orders ON Employee.employee_id = Orders.emp_order_creation_id;

Q2:

SELECT Vendor.company_name, inventory_name, Inventory.std_order_qty

FROM Vendor INNER JOIN Inventory ON Vendor.vendor_id = Inventory.preferred_vendor;

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 (Vendor INNER JOIN Inventory ON Vendor.vendor_id = Inventory.preferred_vendor) INNER JOIN Invoice ON Vendor.vendor_id = Invoice.vendor_id;

Abigail_Dillon · February 26, 2025, 10:08pm

Time to complete: 15 minutes
Rating: Easy

SELECT o.order_id, e. first_name, e.last_name FROM Orders o INNER JOIN e ON o.emp_order_creation_id = e.EmployeeID;
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, inv.emp_received_id, inv.invoice_receipt_date FROM Inventory i INNER JOIN Vendors v ON i.preferred_vendor = v.vendor_id INNER JOIN Invoice inv ON v.vendor_id = inv.vendor_id;

Mackenzie_Janak · February 26, 2025, 10:12pm

Time to complete: 35 minutes
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 Vendor.company_name, Inventory.inventory_name, Inventory.std_order_qty
FROM Vendor
INNER JOIN Inventory ON Vendor.vendor_id = Inventory.preferred_vendor
3.
SELECT OrderDetail.order_id, Invoice.payable_amount
FROM OrderDetail
INNER JOIN Invoice ON OrderDetail.order_id = Invoice.order_id
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

Emmanuel_Mills_Obboh · February 26, 2025, 10:23pm

Time to complete: 25 minutes
Difficulty: Beginner
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;

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

Topic		Replies	Views
179\|SQL – Group By for Greatness Challenges sql , intro , group_by	316	1570	February 27, 2025
176\|SQL – Precision Plane Data Presentation Challenges managerial , sql , intro , planes	324	1639	February 27, 2025
180\|SQL – Intro to Filtering and Ordering Data Challenges filter , sql , intro , order	320	2052	February 27, 2025
178\|SQL – Unions with Precision Challenges sql , union , intro	319	1324	February 27, 2025
181\|SQL – Precision Plane Aggregation Adventure Challenges managerial , sql , intro , planes , having	12	187	March 13, 2025

177|SQL – Intro to Join Statements

Related topics