eroge_sql5.sql

SELECT
  g.sellday,
  g.gamename,
  COUNT(u.game) "count"
FROM gamelist g
INNER JOIN userreview u
  ON g.id = u.game
WHERE
  g.sellday > to_date('2000', 'YYYY')
GROUP BY
  g.sellday,
  g.gamename
ORDER BY
  COUNT(u.game) DESC
LIMIT
  30
;