Search

Programmers

헤비 유저가 소유한 장소

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
복사