エロゲー初心者にお勧めな作品

gistfile1.sql

SELECT G.gamename, S.points
FROM (SELECT game, SUM(CASE WHEN rank = 'A' THEN 3
                            WHEN rank = 'B' THEN 2
                            WHEN rank = 'C' THEN 1
                            ELSE 0 END) AS points
      FROM povgroups
      WHERE pov = 28
      GROUP BY game
      ORDER BY points DESC LIMIT 21) S
INNER JOIN gamelist G
        ON G.id = S.game