Count of new games by yearsの実行結果

SQLの説明

検索結果

実行したSQL

            WITH latest_per_game AS (
  SELECT DISTINCT ON (gamename)
    gamename,
    game_id,
    sellday
  FROM toukei_temp_table
  WHERE sellday IS NOT NULL
    AND sellday <= current_date
  ORDER BY gamename, sellday ASC
)
SELECT
  EXTRACT(YEAR FROM sellday)::INT AS year,
  COUNT(game_id) AS game_count
FROM latest_per_game
GROUP BY year
ORDER BY year DESC;