2021.09.24
SELECT *
FROM review
WHERE item_id IN
(SELECT id FROM item WHERE registration_date<'2018-12-31');
SELECT MAX(copang_report.price) AS max_price,
AVG(copang_report.star) AS avg_star,
COUNT(DISTINCT(copang_report.email)) AS distinct_email_count
FROM
(SELECT price, star, email
FROM review
INNER JOIN item ON item.id=review.item_id
INNER JOIN member ON member.id=review.mem_id) AS copang_report;
명절+개강으로 진도가 점점 느려지고 있다. 어느정도까지 할 수 있을지 잘 모르겠다.