Lions leading passer, Week 1 2024

Level 1 · Challenge 2

Rookie

Prompt

Return the Lions player who led the team in passing yards in Week 1 of the 2024 season, along with their passing yards, completions, and attempts.

Expected output

A single row:

player_display_name	passing_yards	completions	attempts
(player)	(num)	(int)	(int)

Hint

This is almost identical to Challenge 1 — swap the columns from rushing to passing, and add passing_yards IS NOT NULL so non-QBs drop out.

Solution

SELECT player_display_name, passing_yards, completions, attempts
FROM weekly_stats
WHERE recent_team = 'DET'
  AND season = 2024
  AND week = 1
  AND passing_yards IS NOT NULL
ORDER BY passing_yards DESC
LIMIT 1;

Jared Goff. Same answer you’d guess; the query just confirms it.