SQL 퀘스트

> 정답

44. SELECT o.id,
    p.name
    FROM orders o INNER JOIN products p orders o ON o.product_id = p.id;
45. SELECT p.id,
    SUM(p.price*o.quantity) AS total_sales
    FROM products p
    INNER JOIN orders o
    ON p.id=o.product_id
    GROUP BY p.id
    ORDER BY total_sales DESC
    LIMIT 1;
46. SELECT p.id,
    SUM(o.quantity) AS total_quantity
    FROM products p
    INNER JOIN orders o
    ON p.id=o.product_id
    GROUP BY p.id;
47. SELECT p.name
    FROM products p
    INNER JOIN orders o
    ON p.id=o.product_id
    WHERE o.order_date >= '2023-03-03';
48. SELECT p.name,
    SUM(o.quantity) AS total_quantity
    FROM products p
    INNER JOIN orders o
    ON p.id=o.product_id
    GROUP BY p.id
    ORDER BY total_quantity DESC
    LIMIT 1;
49. SELECT p.id,
    AVG(o.quantity) AS avg_quantity
    FROM products p
    INNER JOIN orders o
    ON p.id=o.product_id
    GROUP BY p.id;
50. SELECT p.id,
    p.name
    FROM products p
    LEFT JOIN orders o
    ON p.id=o.product_id
    WHERE o.id is NULL;