[SQL문제풀기 - Advent of SQL 2025 🎅] 크리스마스를 기념할 완벽한 와인 찾기 🥂

문제

solvesql.com

https://solvesql.com/problems/wines-for-friends/

내가 작성한 정답

MySQL, SQLite, PostgreSQL

select *
from wines
where color = 'white' and quality >= 7 
      and density > (select avg(density) from wines) 
      and residual_sugar > (select avg(residual_sugar) from wines)
      and pH < (select avg(pH) from wines where color = 'white') 
      and citric_acid > (select avg(citric_acid) from wines where color = 'white')