Most receiving TDs in a single Lions game, 2024

Starter

Prompt

Find the Lions player-week in 2024 with the most receiving touchdowns. Return the player, the week, the opponent, the receiving yards, and the receiving TDs. Tie-break by receiving yards, then alphabetical by player name.

Expected output

A single row:

player_display_name	week	opponent_team	receiving_yards	receiving_tds
(player)	(int)	(team)	(yards)	(tds)

Hint

ORDER BY receiving_tds DESC, receiving_yards DESC, player_display_name ASC for the tie-break, then LIMIT 1. Watch the column name — it’s receiving_tds, not rec_tds.

Solution

SELECT player_display_name, week, opponent_team,
       receiving_yards, receiving_tds
FROM weekly_stats
WHERE recent_team = 'DET'
  AND season = 2024
  AND season_type = 'REG'
ORDER BY receiving_tds DESC, receiving_yards DESC, player_display_name ASC
LIMIT 1;

Reasonable expectation: Amon-Ra or Jameson Williams, depending on the week.