Skill/postgreSQL

PostgreSQL] count filter 이용

진열사랑 2023. 11. 16. 12:33

출처  :

/* 회원 통계 */
SELECT COUNT(*) 신규회원가입수
, COUNT(1) FILTER (WHERE customer_type_code ='100') AS naver회원가입
, COUNT(1) FILTER (WHERE customer_type_code ='200') AS google회원가입
, COUNT(1) FILTER (WHERE customer_type_code ='300') AS facebook회원가입
  FROM ming.customer_table  
WHERE 1=1
   AND CREATE_DATETIME > CURRENT_DATE - INTERVAL '7 DAY' --지난 일주일간