sql문 질문 2

SELECT 
so.site_id AS site_id, 
ac.c_name AS company_name,
SUM(so.od_cart_price) AS buying_sum 
FROM 
company ac LEFT outer join g5_shop_order so on ac.site_id= so.site_id 
LEFT outer join g5_shop_cart cart on so.od_id=cart.od_id 
LEFT outer join g5_shop_item item on cart.it_id=item.it_id
WHERE so.site_id ='aaa' 
AND cart.ct_status = '완료' 
AND ( item.ca_id LIKE '00%' OR item.ca_id2 LIKE '00%' OR item.ca_id3 LIKE '00%' ) 
AND so.od_test = '0' 
GROUP BY so.site_id order by buying_sum desc