SELECT r.REST_ID, i.REST_NAME, i.FOOD_TYPE, i.FAVORITES, i.ADDRESS, ROUND(avg(REVIEW_SCORE),2) as SCORE
from REST_REVIEW r
left outer join REST_INFO i
on r.REST_ID = i.REST_ID
where ADDRESS like '서울%'
group by REST_ID
order by SCORE desc, FAVORITES desc
ROUND(avg(REVIEW_SCORE),2)
를 했을 때 문제가 발생한다.SELECT column_name(s) FROM table1
UNION
SELECT column_name(s) FROM table2;
NULL AS 새로운 칼럼명
https://www.w3schools.com/sql/sql_union.asp
https://jmkim.tistory.com/50
(SELECT DATE_FORMAT(SALES_DATE, '%Y-%m-%d') as SALES_DATE, PRODUCT_ID, USER_ID, SALES_AMOUNT
from ONLINE_SALE
where YEAR(SALES_DATE) = 2022 and MONTH(SALES_DATE) = 03
Union
SELECT DATE_FORMAT(SALES_DATE, '%Y-%m-%d') as SALES_DATE, PRODUCT_ID, NULL as USER_ID, SALES_AMOUNT
from OFFLINE_SALE
where YEAR(SALES_DATE) = 2022 and MONTH(SALES_DATE) = 03)
order by SALES_DATE, PRODUCT_ID, USER_ID;