, INF3707
ASSIGNMENT 3 2026
DUE AUGUST 2026
Question 1: Chapter 4
SQL code:
SELECT
'SHIPPED' AS ship_status,
order_id,
order_date
FROM my_guitar_shop.orders
WHERE ship_date IS NOT NULL
UNION
SELECT
'NOT SHIPPED' AS ship_status,
order_id,
order_date
FROM my_guitar_shop.orders
WHERE ship_date IS NULL
ORDER BY order_date;
Screenshot:
ASSIGNMENT 3 2026
DUE AUGUST 2026
Question 1: Chapter 4
SQL code:
SELECT
'SHIPPED' AS ship_status,
order_id,
order_date
FROM my_guitar_shop.orders
WHERE ship_date IS NOT NULL
UNION
SELECT
'NOT SHIPPED' AS ship_status,
order_id,
order_date
FROM my_guitar_shop.orders
WHERE ship_date IS NULL
ORDER BY order_date;
Screenshot: