Hi — Jenna from Marketing.

The first matches have happened and we're starting to see real consumer behavior. Before our 8am team meeting tomorrow, I need a clean view of yesterday's sales — broken down by team and by metro area.

Specifically, write a query that returns yesterday's sales (date = '2026-06-11', the opening day with Mexico vs South Africa and South Korea vs Czechia), aggregated to: team, metro area, total units sold, total net revenue in dollars.

Rules I need you to follow: - Use the v_sales_enriched view (it already joins sales_daily with teams, products, players, and stores — no need to write the joins manually) - Filter to sales_date = '2026-06-11' - Group by team_name and metro_area - Show net revenue in DOLLARS, not cents (divide net_revenue_cents by 100) - Sort by net…