SELECT CONCAT(CLDR_YY, CLDR_MM) AS "월별", COUNT(*) AS "영업일" FROM ( SELECT DISTINCT CLDR_YY, CLDR_MM, CLDR_DD, CLDR_DATE, CLDR_WEEK FROM ATN_CALENDAR WHERE HLDY_YN !='Y' -- 영업일 AND CLDR_YY ='2022' )X GROUP BY CONCAT(CLDR_YY, CLDR_MM)

SELECT TO_CHAR (REG_DATE, 'YYYY-MM-DD') AS "접수일", COUNT (1) "접수건수", SUM (COUNT (1)) OVER (ORDER BY TO_CHAR (REG_DATE, 'YYYY-MM-DD')) "누적접수건수" FROM N_BOARD_EVENT GROUP BY TO_CHAR (REG_DATE, 'YYYY-MM-DD') ORDER BY TO_CHAR (REG_DATE, 'YYYY-MM-DD')

SELECT '신청: '||TOTAL||'건(전체), '||P_TYPE||'건(PC), '||M_TYPE||'건(모바일)' AS EVENT_MFROM(SELECT COUNT (1) AS TOTAL, COUNT (DECODE (TYPE, 'P', 'P')) AS P_TYPE, COUNT (DECODE (TYPE, 'M', 'M')) AS M_TYPE FROM N_BOARD_EVENT)

SELECT UPPER(MEMBER_ID),COUNT(UPPER(MEMBER_ID)) FROM MEMBER_INFO GROUP BY UPPER(MEMBER_ID) HAVING COUNT(UPPER(MEMBER_ID)) > 1