헤비 유저가 소유한 장소
SELECT A.ID
,A.NAME
,A.HOST_ID
FROM PLACES A
INNER JOIN (
SELECT HOST_ID
FROM PLACES
GROUP BY HOST_ID
HAVING COUNT(DISTINCT ID) >= 2) B ON A.HOST_ID = B.HOST_ID
ORDER BY A.ID;
SQL
복사
우유와 요거트가 담긴 장바구니
SELECT CART_ID
FROM CART_PRODUCTS
GROUP BY CART_ID
HAVING COUNT(IF(NAME = 'Milk',1,NULL)) >= 1 AND COUNT(IF(NAME = 'Yogurt',1,NULL)) >= 1
ORDER BY CART_ID;
SQL
복사