Oracle) Date 타입 날짜 검색

• 날짜 검색법 https://devkingdom.tistory.com/137

SELECT openDt, TO_CHAR(openDt, 'yyyy') AS year
FROM tbl_movie;

SELECT iv.year , count(iv.year)
FROM (
    SELECT openDt, TO_CHAR(openDt, 'yyyy') AS year
    FROM tbl_movie
)iv
GROUP BY iv.year
ORDER BY iv.year DESC