日付別にデータを取得
SELECT TO_CHAR( entry_date, 'YYYYMMDD' ) as DAY, COUNT( TO_CHAR(entry_date, 'YYYYMMDD') ) as COUNT FROM test_table GROUP BY DAY ORDER BY DAY;
SELECT TO_CHAR( entry_date, 'YYYYMMDD' ) as DAY, COUNT( TO_CHAR(entry_date, 'YYYYMMDD') ) as COUNT FROM test_table GROUP BY DAY ORDER BY DAY;