```json { "queries": [ { "query": "SELECT \"Champion\", COUNT(*) AS titles FROM world_cup GROUP BY 1 ORDER BY 2 DESC LIMIT 10", "description": "Countries with the most World Cup titles, ranked by number of championships won." }, { "query": "SELECT \"Year\", \"Champion\", \"Runner-Up\", \"Attendance\" FROM world_cup ORDER BY \"Attendance\" DESC LIMIT 10", "description": "World Cups with highest total attendance, showing champion and runner-up for each tournament." }, { "query": "SELECT home_team, COUNT(*) AS matches_played FROM matches_1930_2022 WHERE home_team = 'Brazil' OR away_team = 'Brazil' GROUP BY 1", "description": "Total number of World Cup matches played by Brazil across all tournaments." }, { "query": "SELECT home_team, away_team, home_score, away_score, \"Year\", \"Round\" FROM matches_1930_2022 WHERE home_score + away_score >= 10 ORDER BY home_score + away_score DESC LIMIT 10", "description": "Highest-scoring World Cup matches in history, showing teams, scores, year, and round." }, { "query": "SELECT team, association, rank, points FROM fifa_ranking_2026_06_08 WHERE association = 'UEFA' ORDER BY rank LIMIT 10", "description": "Top 10 UEFA teams in the June 2026 FIFA rankings by rank position." }, { "query": "SELECT association, COUNT(*) AS teams, AVG(points) AS avg_points FROM fifa_ranking_2026_06_08 GROUP BY 1 ORDER BY 3 DESC", "description": "Average FIFA ranking points by continental association, showing strength of each confederation." }, { "query": "SELECT home_team, SUM(home_score) AS total_goals FROM matches_1930_2022 WHERE home_team = 'Germany' GROUP BY 1", "description": "Total goals scored by Germany as the home team across all World Cup matches." }, { "query": "SELECT \"Venue\", COUNT(*) AS matches FROM matches_1930_2022 WHERE \"Venue\" IS NOT NULL GROUP BY 1 ORDER BY 2 DESC LIMIT 10", "description": "Stadiums that have hosted the most World Cup matches throughout history." }, { "query": "SELECT team, rank, previous_rank, (previous_rank - rank) AS rank_change FROM fifa_ranking_2026_06_08 WHERE previous_rank IS NOT NULL ORDER BY rank_change DESC LIMIT 10", "description": "Teams with the biggest positive rank improvements in the June 2026 FIFA rankings." }, { "query": "SELECT \"Year\", \"Host\", \"Teams\", \"Matches\", \"AttendanceAvg\" FROM world_cup ORDER BY \"Year\" DESC LIMIT 10", "description": "Most recent World Cup tournaments showing host country, number of teams, and average attendance." } ] } ```