SQL Queries for Database Setup Assignment Answers
Your question:
Assignment Help Answers with Step-by-Step Explanation:
SELECT product_id, description, price
FROM Product
JOIN AppUser AS A ON C.user_id = A.user_id;
3) Find the customer name, phone numbers, and order ID of all orders that have "New" in the status. If the customer has multiple phone numbers, concatenate them by commas in the result (Hint: use GROUP_CONCAT).
JOIN PrintOrder AS PO ON A.user_id = PO.user_id
WHERE PO.status = 'New'
JOIN Product AS P ON I.product_id = P.product_id
WHERE I.order_id = 3;
JOIN Product AS P ON I.product_id = P.product_id
WHERE PO.user_id = 'S'
JOIN Customer AS C ON A.user_id = C.user_id
JOIN Admin AS Ad ON A.user_id = Ad.user_id;
LEFT JOIN Admin AS Supervisor ON Ad.user_id = Supervisor.supervisor_id
WHERE Supervisor.supervisor_id IS NULL;
LEFT JOIN Image AS IM ON AL.album_id = IM.album_id
GROUP BY AL.album_id, AL.name, AL.creation_date
LEFT JOIN Item AS I ON IM.album_id = I.album_id AND IM.image_id = I.image_id
WHERE IM.album_id = 1
JOIN PrintOrder AS PO ON A.user_id = PO.user_id
JOIN (
JOIN Item AS I ON PO.order_id = I.order_id
GROUP BY PO.order_id