Open Freddicola opened 1 year ago
select
rental.customer_id,
customer.first_name,
customer.last_name,
count(rental.customer_id) as cnt_id
from
rental
inner join
customer
on rental.customer_id = customer.customer_id
group by
rental.customer_id,
customer.first_name,
customer.last_name
order by
cnt_id desc
SELECT 컬럼 FROM 테이블이름 WHERE 검색조건 GROUP BY 컬럼 ORDER BY 컬럼
site: https://velog.io/@jen_jyseo/DataBase-%EA%B7%B8%EB%A3%B9%EC%A1%B0%ED%9A%8C