Top 5 NFL rushers, Week 1 2024

All-Pro

Prompt

The Lions filter is gone. Return the top 5 NFL rushers of Week 1, 2024 — their name, team, rushing yards, carries, and rushing TDs. Sort by rushing yards descending, tie-break by TDs.

Expected output

Five rows:

player_display_name	recent_team	rushing_yards	carries	rushing_tds
(player)	(team)	(yards)	(carries)	(tds)

Hint

Drop the recent_team = 'DET' filter. Keep season = 2024 AND week = 1. Add carries IS NOT NULL so you don’t get a string of zero-carry receivers tied at the bottom.

Solution

SELECT player_display_name, recent_team, rushing_yards, carries, rushing_tds
FROM weekly_stats
WHERE season = 2024
  AND week = 1
  AND season_type = 'REG'
  AND carries IS NOT NULL
ORDER BY rushing_yards DESC, rushing_tds DESC
LIMIT 5;

Why this matters: every Level 2+ analysis needs cross-team queries. Getting comfortable removing the team filter is its own small skill.