SQLD(SQL 개발자) 기출 · DML

이 문제 풀어보기

1. 1.SELECT SVC_ID, COUNT(*) AS CNT
   FROM SVC_JOIN
   WHERE TO_DATE(’201501’, 'YYYYMM') = SVC_END_DATE
   AND JOIN_YMD| |JOIN_HH = '2014120100’
   GROUP BY SVC_ID;
2. 2.SELECT SVC_ID, COUNT(*) AS CNT
   FROM SVC_JOIN
   WHERE ’201501’ = TO_CHAR(SVC_END_DATE, 'YYYYMM')
   AND JOIN_YMD = ’20141201’
   AND JOIN _HH = '00'
   GROUP BY SVC_ID;
3. 3.SELECT SVC_ID, COUNT(*) AS CNT
   FROM SVC_JOIN
   WHERE SVC_END_DATE〉= TO_DATE(’20150101’, 'YYYYMMDD')
   AND SVC_END_DATE < TO_DATE(’20150201’, 'YYYYMMDD')
   AND (JOIN_YMD, JOIN_HH) IN (('20141201', '00'))
   GROUP BY SVC_ID;
4. 4.SELECT SVC_ID, COUNT(*) AS CNT
   FROM SVC_JOIN
   WHERE SVC_END_DATE >= TO_DATE(’20150101000000',
   'YYYYMMDDHH24MISS')
   AND SVC_END_DATE <= TO_DATE(’20150131235959’,
   ’YYYYMMDDHH24MISS’)
   AND CONCAT(JOIN_YMD, JOIN_HH) = '2014120100'
   GROUP BY SVC_ID；