코딩테스트 연습(Level.2) / MySQL

코드 풀이

SELECT INFO.REST_ID, INFO.REST_NAME, INFO.FOOD_TYPE, 
INFO.FAVORITES, INFO.ADDRESS,
ROUND(AVG(REVIEW_SCORE),2) AS SCORE From REST_INFO as INFO
LEFT JOIN REST_REVIEW AS REVIEW ON INFO.REST_ID = REVIEW.REST_ID
where INFO.ADDRESS like "서울%"
Group by INFO.REST_ID
having SCORE is not null
order by SCORE desc, INFO.FAVORITES DESC;

SELECT DATE_FORMAT(SALES_DATE, '%Y-%m-%d') AS SALES_DATE, 
PRODUCT_ID, USER_ID, SALES_AMOUNT FROM ONLINE_SALE
WHERE MONTH(SALES_DATE)=3 AND YEAR(SALES_DATE)=2022
UNION
SELECT DATE_FORMAT(SALES_DATE, '%Y-%m-%d') AS SALES_DATE, 
PRODUCT_ID, NULL AS USER_ID, SALES_AMOUNT FROM OFFLINE_SALE
WHERE MONTH(SALES_DATE)=3 AND YEAR(SALES_DATE)=2022
ORDER BY SALES_DATE ASC, PRODUCT_ID ASC, USER_ID ASC