[SQL문제풀기 - Advent of SQL 2025 🎅] 이달의 작가 후보 찾기

문제

solvesql.com

https://solvesql.com/problems/monthly-author-candidates/

내가 작성한 정답

MySQL, PostgreSQL, SQLite

select author
from books
where genre = 'Fiction'
group by author
having count(year)>=2
    and avg(user_rating) >= 4.5
    and avg(reviews) >= (select avg(reviews) from books where genre = 'Fiction')
order by 1;