진행할 과제/논의할 과제
과제에서 필수 사용되는 문법 요약
INNER JOIN
LEFT JOIN
SUM
AVG
LIMIT
팀원 코드 공유
이예리
전민정
홍대현
Best Practice
타인의 코드에 대해 피드백 할 때에는 항상 피드백을 받는 사람이 성장했으면 하는 마음을 담아 피드백 해주세요.
BEST
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;
SQL
복사