Answer & Explanation:
1) Query:
SELECT Product_Name, Category_Name, List_Price
FROM Products AS P JOIN Categories AS C
ON C.Category_ID = P.Category_ID
ORDER BY Category_Name, Product_Name ASC;
2) Query:
SELECT C.Last_Name, C.First_Name, Order_Date, P.Product_Name, Item_Price, Discount_Amount, Quantity
FROM Customers AS C JOIN Orders AS O
ON C.Customer_ID = O.Customer_ID
JOIN Order_Items AS OI
ON O.Order_ID = OI.Order_ID
JOIN Products AS P
ON OI.Product_ID = P.Product_ID
ORDER BY Last_Name, Order_Date, Product_Name;
3) Query:
SELECT Category_Name, Product_ID
FROM Categories LEFT JOIN Products
ON Categories.Category_ID = Products.Category_ID
WHERE Product_ID IS NULL;
4) Query:
SELECT 'SHIPPED' AS Ship_Status, Order_Id, Order_Date
FROM Orders
WHERE Ship_Date IS NOT NULL
UNION
SELECT 'NOT SHIPPED' AS Ship_Status, Order_ID, Order_Date
FROM Orders
WHERE Ship_Date IS NULL
ORDER BY Order_Date;
