MySQL - group by의 having 사용 방법

having

 

 

 

group by의 조건문에는

 

where가 아닌 having을 쓰는 것이다.

 

 

 

 

각 고객별로 주문 금액 평균이 300달러 이상인 데이터만 가져오시오

select c.first_name, c.last_name, avg(o.amount) as AVG
from customers c
join orders o
on c.id = o.customer_id
group by c.id having avg(o.amount) >= 300 ;

 

 

 

 

각 고객별로 주문 금액 최대값이 600달러 이상인 데이터만 가져와서 내림차순으로 정렬하시오

select c.first_name, c.last_name, max(o.amount) as MAX
from customers c
join orders o
on c.id = o.customer_id
group by c.id having max(o.amount) >= 600
order by MAX desc;