180|SQL – Intro to Filtering and Ordering Data

[Tyler_Loose]

Time: 15 minutes
Difficulty: Easy

1. SELECT i.inventory_name, i.inventory_id, o.order_id, od.qty_ordered, o.order_sent_date
   FROM (Inventory AS i INNER JOIN OrderDetail AS od ON i.inventory_id = od.inventory_id) INNER JOIN Orders AS o ON od.order_id = o.order_id
   WHERE i.inventory_id = 27
   ORDER BY order_sent_date DESC

2. SELECT i.invoice_id, e.first_name, e.last_name, i.payable_amount
   FROM Employee AS e INNER JOIN Invoice AS i ON e.employee_id = i.emp_received_id
   WHERE emp_received_id = 18
   ORDER BY payable_amount DESC

[Tessa_Staley]

Time to complete: 10
Difficulty: easy
Solution:

1. SELECT inventory.inventory_name, inventory.inventory_id, orders.order_id, orderdetail.qty_ordered, orders.order_sent_date
   FROM (inventory INNER JOIN orderdetail ON inventory.inventory_id=orderdetail.inventory_id) INNER JOIN orders ON orderdetail.order_id=orders.order_id
   WHERE inventory.inventory_id=27
   ORDER BY orders.order_sent_date DESC;

2. SELECT invoice.invoice_id, employee.first_name, employee.last_name, invoice.payable_amount
   FROM Invoice INNER JOIN Employee ON invoice.emp_received_id=employee.employee_id
   WHERE emp_received_id=18
   ORDER BY invoice.payable_amount DESC

[Jared_Divelbiss]

Time: 15
Difficulty: Beginner
Solution:

SELECT i.inventory_name, i.inventory_id, od.order_id, od.qty_ordered, o.order_sent_date
FROM (Inventory i INNER JOIN OrderDetail as od ON i.inventory_id = od.inventory_id)
INNER JOIN Orders AS o ON od.order_id = o.order_id
WHERE i.inventory_id = 27
ORDER BY o.order_sent_date DESC;

SELECT i.invoice_id, e.first_name, e.last_name, i.payable_amount
FROM Invoice i
INNER JOIN Employee AS e ON i.emp_received_id = e.employee_id
WHERE i.emp_received_id = 18
ORDER BY i.payable_amount DESC;

[Collin_Simon]

Time to complete: 15 min
Difficulty: Easy

SELECT i.inventory_name, i.inventory_id, o.orderid, od.qty_ordered, od.order_sent_date
From Inventory as i
Inner join orders as o on i.inventory_id = o.inventory_id
Inner join OrderDetail as od on o.order_id = od.order_id
Where inventory_id = 27
Order by od.order_sent_date DESC;

SELECT i.invoice_id, e.first_name, e.last_name, i.payable_amount
From Invoice as i
Right Join Employee as e on i.emp_received_id = e.employee_id
Where i.emp_received_id = 18
Order by i.payable_amount desc;

[Kameron_K_Sakamoto]

Time to Complete: 15min
Difficulty: Beginner
Solution:

Q1:
SELECT i.inventory_name, i.inventory_id, od.order_id, qty_ordered, o.order_sent_date
FROM (Inventory AS i INNER JOIN OrderDetail AS od ON od.inventory_id = i.inventory_id)
INNER JOIN Orders AS o ON o.order_id = od.order_id
WHERE i.inventory_id = 27
ORDER BY o.order_sent_date DESC;

Q2:

SELECT inv.invoice_id, e.first_name, e.last_name, inv.payable_amount
FROM Invoice AS inv INNER JOIN Employee AS e ON inv.emp_received_id = e.employee_id
WHERE e.employee_id = 18
ORDER BY inv.payable_amount DESC;

[Colter_Sill]

Time to Complete: 15 Mins
Difficulty: Beginner
Solution:
1.SELECT i.inventory_name, i.inventory_id, o.order_id, od.qty_ordered, o.order_sent_date
FROM (Inventory AS i INNER JOIN OrderDetail AS od ON i.inventory_id = od.inventory_id)
INNER JOIN Orders AS o ON o.order_id = od.order_id
WHERE i.inventory_id = 27
ORDER BY o.order_sent_date DESC;
2.SELECT inv.invoice_id, e.first_name, e.last_name, inv.payable_amount
FROM Invoice AS inv
INNER JOIN Employee AS e ON inv.emp_received_id = e.employee_id
WHERE inv.emp_received_id = 18
ORDER BY inv.payable_amount DESC;

[Elisabeth_Ware]

Time to complete: 10
Difficulty: Easy
Solution:

1. SELECT i.inventory_name, i.inventory_id, o.order_id, od.qty_ordered, o.order_sent_date
   FROM (Inventory i INNER JOIN OrderDetail od ON i.inventory_id=od.inventory_id)
   INNER JOIN Orders o ON od.order_id=o.order_id
   WHERE i.inventory_id=27
   ORDER BY o.order_sent_date;

2. SELECT i.invoice_id, e.first_name, e.last_name, i.payable_amount
   FROM Invoice as i
   INNER JOIN Employee as e ON i.emp_received_id = e.employee_id
   WHERE e.employee_id = 18
   ORDER BY i.payable_amount DESC;

[Genevieve_Nichols]

Q1: SELECT i.inventory_name, i.inventory_id, od.order_id, od.qty_ordered, o.order_sent_date
FROM (Inventory AS i INNER JOIN OrderDetail AS od ON i.inventory_id = od.inventory_id) INNER JOIN Orders AS o ON od.order_id = o.order_id
WHERE i.inventory_id = 27
ORDER BY o.order_sent_date DESC;

Q2: SELECT i.invoice_id, e.first_name, e.last_name, i.payable_amount
FROM Invoice AS i RIGHT JOIN Employee AS e ON i.emp_received_id = e.employee_id
WHERE i.emp_received_id = 18
ORDER BY i.payable_amount DESC;

[Sophie_Dong]

Time to Complete: 15 minutes
Difficulty: Easy
Solution: See Below
1:
SELECT i.inventory_name, i.inventory_id, o.order_id, od.qty_ordered, o.order_sent_date
FROM (Inventory as i INNER JOIN OrderDetail as od ON i.inventory_id = od.inventory_id)
INNER JOIN Orders as o ON od.order_id = o.order_id
WHERE i.inventory_id = 27
ORDER BY o.order_sent_date DESC;
2:
SELECT i.invoice_id, e.first_name, e.last_name, i.payable_amount
FROM Invoice as i
RIGHT JOIN Employee as e ON i.emp_received_id = e.employee_id
WHERE e.employee_id = 18
ORDER BY i.payable_amount DESC;

[Dayna_Ranta]

Time to Complete: 10 minutes
Rating: Easy
Solutions:

1. SELECT i.inventory_name, i.inventory_id, od.order_id, od.qty_ordered, o.order_sent_date
   FROM (Inventory AS i
   INNER JOIN OrderDetail AS od ON i.inventory_id = od.inventory_id)
   INNER JOIN Orders AS o ON od.order_id = o.order_id
   WHERE i.inventory_id = 27
   ORDER BY o.order_sent_date DESC;

2. SELECT i.invoice_id, e.first_name, e.last_name, i.payable_amount
   FROM Invoice AS i INNER JOIN Employee AS e ON e.employee_id = i.emp_received_id
   WHERE emp_received_id = 18
   ORDER BY i.payable_amount DESC;

[Sydney_Clove]

1. SELECT i.inventory_name, i.inventory_id, o.order_id, od.qty_ordered, o.order_sent_date
   FROM (Inventory i INNER JOIN OrderDetail od ON i.inventory_id = od.inventory_id)
   INNER JOIN Orders o ON od.order_id = o.order_id
   WHERE i.inventory_id = 27
   ORDER BY o.order_sent_date DESC
2. SELECT i.invoice_id, e.first_name, e.last_name, i.payable_amount
   FROM (Invoice i RIGHT JOIN Employee e ON e.employee_id = i.emp_received_id)
   WHERE i.emp_received_id = 18
   ORDER BY i.payable_amount DESC;

[Ashleigh_Layton]

Time to complete: 15 min
Difficulty: Beginner
Solution:

1. SELECT i.inventory_name, i.inventory_id, od.order_id, od.qty_ordered, o.order_sent_date
   FROM (Inventory AS i
   INNER JOIN OrderDetail AS od ON i.inventory_id = od.inventory_id)
   INNER JOIN Orders AS o ON od.order_id = o.order_id
   WHERE i.inventory_id = 27
   ORDER BY o.order_sent_date DESC;
2. SELECT inv.invoice_id, e.first_name, e.last_name, inv.payable_amount
   FROM Invoice AS inv
   INNER JOIN Employee AS e ON inv.emp_received_id = e.employee_id
   WHERE inv.emp_received_id = 18
   ORDER BY inv.payable_amount DESC;

[Andrew_Benson]

Time to Complete: 10 Minutes
Difficulty: Easy
Solutions:
1.
SELECT i.inventory_name, i.inventory_id, o.order_id, od.qty_ordered, o.order_sent_date
FROM ((Inventory i
INNER JOIN OrderDetail od ON i.inventory_id=od.inventory_id)
INNER JOIN Orders o ON od.order_id=o.order_id)
WHERE i.inventory_id=27
ORDER BY order_sent_date DESC

SELECT invoice_id, first_name, last_name, payable_amount
FROM Employee e
INNER JOIN Invoice i ON e.employee_id=i.emp_received_id
WHERE i.emp_received_id=18
ORDER BY payable_amount DESC

[Ethan_Benoit]

Time to Complete: 15 Minutes
Difficulty: Easy
See Solution Below:
1:
SELECT i.inventory_name, i.inventory_id, o.order_id, od.qty_ordered, o.order_sent_date
From (inventory as i inner join orderdetail as od on i.inventory_id = od.inventory_id)
Inner Join Orders as o on od.order_id = o.order_id
Where i.inventory_id = 27
Order By order_sent_date DESC;
2:
SELECT inv.invoice_id, e.first_name, e.last_name, inv.payable_amount
From invoice as inv
inner join employee as e on inv.emp_received_id = e.employee_id
Where emp_received_id = 18
Order By inv.payable_amount DESC ;

[Lindsay_Shields]

Time to complete: 10 minutes
Difficulty: easy

Q1:
SELECT i.inventory_name, i.inventory_id, o.order_id, od.qty_ordered, o.order_sent_date
FROM (Inventory i
INNER JOIN OrderDetail od ON i.inventory_id = od.inventory_id)
INNER JOIN Orders o ON od.order_id = o.order_id
WHERE i.inventory_id=27
ORDER BY order_sent_date DESC;

Q2:
SELECT invoice_id, first_name, last_name, payable_amount
FROM Invoice
INNER JOIN Employee on Invoice.emp_received_id = Employee.employee_id
WHERE emp_received_id = 18
ORDER BY payable_amount DESC;

[Carter_McQuivey]

Time: 25 minutes
Difficulty: medium
Solutions:

Q1:
SELECT Inventory.inventory_name, Inventory.inventory_id, Orders.order_id, OrderDetail.qty_ordered, Orders.order_sent_date
FROM (Inventory INNER JOIN OrderDetail ON Inventory.inventory_id=OrderDetail.inventory_id)
INNER JOIN Orders ON OrderDetail.order_id=Orders.order_id
WHERE Inventory.inventory_id=27
ORDER BY Orders.order_sent_date DESC

Q2:
SELECT Invoice.invoice_id, Employee.first_name, Employee.last_name, Invoice.payable_amount
FROM (Invoice INNER JOIN Employee ON Invoice.emp_received_id=Employee.employee_id)
WHERE Invoice.emp_received_id=18
ORDER BY Invoice.payable_amount DESC

[Liam_Smith]

SELECT i.inventory_name, od.inventory_id, od.order_id, od.qty_ordered, o.order_send_date
FROM inventory i
INNER JOIN OrderDetail od ON i.inventory_id = od.inventory_id
INNER JOIN Orders o ON od.order_id = o.order_id
WHERE i.inventory_id = 27
ORDER BY o.order_send_date DESC

SELECT i.invoice_id, e.first_name, e.last_name, i.payable_amount
FROM Invoice i
INNER JOIN Employee e ON i.emp_received_id = e.employee_id
WHERE i.emp_received_id = 18
ORDER BY i.payable_amount DESC;

[Moa_Redford]

SELECT inventory_name, inventory_id, order_id, qty_ordered, order_sent_date
FROM inventory i
INNER JOIN OrderDetail AS od ON i.inventory_id = od.inventory_id
INNER JOIN Order AS o ON od.order_id = o.order_id
WHERE inventory_id = 27
ORDER BY order_sent_date DESC ;

SELECT invoice_id, first_name, last_name, payable_amount
FROM Invoice i
INNER JOIN Employee AS e On i.employee_id = e.employee_id
WHERE emp_received_id = 18
ORDER BY i.payable_amount DESC ;

[Anela_Zamarron]

Query 1
Select i.inventory_name, od.inventory_id, od.order_id, od.qty_ordered, o.order_sent_date
From OrderDetail od
Inner Join Inventory i on od.inventory_id = i.inventory_id
Inner Join Orders o on od.order_id = o.order_id
Where od.inventory_id = 27
Order By o.order_sent_date DESC;

Query 2
Select i.invoice_id, e.first_name, e.last_name, i.payable_amount
From Invoice i
Inner Join Employee e on i.emp_received_id = e.employee_id
Where i.emp_received_id = 18
Order By i.payable_amount DESC;

[James_Lloyd]

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

SELECT i.inventory_name, i.inventory_id, od.order_id, od.qty_ordered, o.order_sent_date
From (Inventory i Inner Join OrderDetail od On i.inventory_id = od.inventory_id)
Inner Join Orders o On od.order_id = o.order_id
Where i.inventory_id = 27
Order By o.order_sent_date DESC

SELECT i.invoice_id, e.first_name, e.last_name, i.payable_amount
FROM Invoice as i
RIGHT JOIN Employee as e ON i.emp_received_id = e.employee_id
WHERE e.employee_id = 18
ORDER BY i.payable_amount DESC;