課題内容
投稿期間外となりますので、投稿は受け付けておりません。
SELECT MAKEUP_TITLE_CD,
MAKEUP_TITLE,
DATE_FORMAT(LIMIT_DATE_S,'%Y年%m月%d日') AS LIMIT_S,
DATE_FORMAT(LIMIT_DATE_E,'%Y年%m月%d日') AS LIMIT_E
FROM
T_MAKEUP_TITLE_NEW
WHERE
T_MAKEUP_TITLE_NEW.LIMIT_DATE_S <='2020-12-05'
AND
T_MAKEUP_TITLE_NEW.LIMIT_DATE_E > '2020-12-05' AND
T_MAKEUP_TITLE_NEW.MAKEUP_TITLE =''