1SELECT st.rank as "Rank", st.team_name as "Team", st.points as "Points", st.played as "Played", st.goals_for as "Goals For",
2                st.goals_against as "Goals Against", st.goal_difference as "Goal Diff", 
3                coalesce(st.form, '') as 'Form', st.wins as "W", st.draws as "D", st.losses as "L"
4FROM @blt.ultimate_soccer_dataset.standings st
5INNER JOIN @blt.ultimate_soccer_dataset.seasons s ON (st.season_id = s.season_id)
6INNER JOIN @blt.ultimate_soccer_dataset.competitions c ON (s.competition_id = c.competition_id)
7WHERE c.slug = 'world-cup' and s.season_label = '2026' and st.group = 'Group B'
8ORDER BY st.snapshot_date DESC, rank
9LIMIT 4