240730_TIL

아무리 사소하더라도 배움이 없는 날은 없다.

SQL 코드카타

문제 링크

WITH result
     AS (SELECT customer_id,
                Count(amount) AS "cnt"
         FROM   store
         WHERE  amount > 500
         GROUP  BY 1
         HAVING cnt >= 1)
SELECT Count(DISTINCT customer_id) AS "rich_count"
FROM   result;