[SQL문제풀기 - Advent of SQL 2025 🎅] DVD 대여점 우수 고객 찾기

문제

solvesql.com

https://solvesql.com/problems/dvdrental-vip/

내가 작성한 오답

select distinct active from customer; 

active가 1이면 유효고객 0이면 무효고객?이었다.

내가 작성한 정답

MySQL, SQLlite

select r.customer_id
from rental r
join customer c on r.customer_id = c.customer_id and c.active = 1
group by r.customer_id
having count(distinct r.rental_id) >= 35;

PostgreSQL

select r.customer_id
from rental r
join customer c on r.customer_id = c.customer_id and c.active
group by r.customer_id
having count(distinct r.rental_id) >= 35;