Lions rushing leaderboard, 2024

Rookie

Prompt

Return Lions 2024 regular-season rushing leaderboard: player name, games with at least one carry, total carries, total rushing yards, total rushing TDs, yards per carry. Sort by yards descending.

Expected output

player_display_name	games	carries	yards	tds	ypc
(player)	(int)	(int)	(int)	(int)	(decimal)

Hint

GROUP BY player_display_name. COUNT(*) for games (already filtered to rows with carries). YPC is SUM(rushing_yards)::numeric / NULLIF(SUM(carries), 0).

Solution

SELECT
    player_display_name,
    COUNT(*)                                                AS games,
    SUM(carries)                                            AS carries,
    SUM(rushing_yards)                                      AS yards,
    SUM(rushing_tds)                                        AS tds,
    ROUND(SUM(rushing_yards)::numeric / NULLIF(SUM(carries), 0), 2) AS ypc
FROM weekly_stats
WHERE recent_team = 'DET'
  AND season = 2024
  AND season_type = 'REG'
  AND carries IS NOT NULL
  AND carries > 0
GROUP BY player_display_name
ORDER BY yards DESC;

Gibbs on top (≈1,400 yds), Montgomery next (≈775), then situational backs, then Goff sneaks.