Lions leading rusher, Week 1 2024

Rookie

Prompt

Return the single player who led the Detroit Lions in rushing yards in Week 1 of the 2024 season, along with their rushing yards and rushing touchdowns.

Expected output

A single row with three columns:

player_display_name	rushing_yards	rushing_tds
(player)	(int)	(int)

Hint

You want ORDER BY rushing_yards DESC plus LIMIT 1 to grab only the leader. Filter on recent_team = 'DET', season = 2024, and week = 1.

Solution

SELECT player_display_name, rushing_yards, rushing_tds
FROM weekly_stats
WHERE recent_team = 'DET'
  AND season = 2024
  AND week = 1
ORDER BY rushing_yards DESC
LIMIT 1;

David Montgomery led the Lions in rushing in their 2024 opener at the Rams (an OT loss). The query stays the same whether they won or lost — it’s just asking “who ran for the most yards?”