728x90 강의과제1 [SQL 스터디] 8일차 섹션4, EXERCISES SELECT * FROM fruit_imports SELECT state FROM fruit_imports GROUP BY state ORDER BY SUM(supply) DESC LIMIT 1 SELECT season, MAX(cost_per_unit) highest_cost_per_unit FROM fruit_imports GROUP BY season ORDER BY MAX(cost_per_unit) DESC SELECT state FROM fruit_imports GROUP BY state, name HAVING count(name) > 1 SELECT season, count(*) FROM fruit_imports GROUP BY season HAVING count(*) = 3 or count(*.. 2020. 3. 10. 이전 1 다음 반응형
