RUBY

SELECT date_format(SALES_DATE, '%Y-%m-%d') as SALES_DATE, PRODUCT_ID, USER_ID, SALES_AMOUNT FROM ONLINE_SALE WHERE SALES_DATE BETWEEN '2022-03-01' and '2022-03-31' UNION ALL SELECT date_format(SALES_DATE, '%Y-%m-%d') as SALES_DATE, PRODUCT_ID, NULL as USER_ID, SALES_AMOUNT FROM OFFLINE_SALE WHERE SALES_DATE BETWEEN '2022-03-01' and '2022-03-31' ORDER BY SALES_DATE, PRODUCT_ID, USER_ID

SELECT FLAVOR FROM FIRST_HALF LEFT OUTER JOIN ICECREAM_INFO USING(FLAVOR) WHERE TOTAL_ORDER > 3000 AND INGREDIENT_TYPE = 'fruit_based'

SELECT BOOK_ID, DATE_FORMAT(PUBLISHED_DATE, '%Y-%m-%d') as PUBLISHED_DATE FROM BOOK WHERE CATEGORY = '인문' AND PUBLISHED_DATE BETWEEN '2021-01-01 00:00:00' AND '2021-12-31 00:00:00' ORDER BY PUBLISHED_DATE