```json { "queries": [ { "query": "SELECT \"Country\", COUNT(*) AS supercomputer_count FROM ai_supercomputers WHERE \"Country\" IS NOT NULL GROUP BY \"Country\" ORDER BY supercomputer_count DESC LIMIT 10", "description": "Top 10 countries by number of AI supercomputers." }, { "query": "SELECT \"Owner\", COUNT(*) AS count FROM ai_supercomputers WHERE \"Owner\" IS NOT NULL GROUP BY \"Owner\" ORDER BY count DESC LIMIT 10", "description": "Organizations owning the most AI supercomputers." }, { "query": "SELECT \"Chip type (primary)\", COUNT(*) AS count FROM ai_supercomputers WHERE \"Chip type (primary)\" IS NOT NULL GROUP BY \"Chip type (primary)\" ORDER BY count DESC LIMIT 10", "description": "Most commonly used primary chip types in AI supercomputers." }, { "query": "SELECT \"Name\", \"Owner\", \"Country\", \"H100 equivalents\" FROM ai_supercomputers WHERE \"H100 equivalents\" IS NOT NULL ORDER BY \"H100 equivalents\" DESC LIMIT 10", "description": "Top 10 most powerful AI supercomputers by H100 equivalent performance." }, { "query": "SELECT \"Sector\", COUNT(*) AS count FROM ai_supercomputers WHERE \"Sector\" IS NOT NULL GROUP BY \"Sector\" ORDER BY count DESC", "description": "Distribution of AI supercomputers across different sectors." }, { "query": "SELECT \"Status\", COUNT(*) AS count FROM ai_supercomputers WHERE \"Status\" IS NOT NULL GROUP BY \"Status\" ORDER BY count DESC", "description": "Breakdown of AI supercomputers by operational status." }, { "query": "SELECT \"Name\", \"Owner\", \"Power Capacity (MW)\", \"Country\" FROM ai_supercomputers WHERE \"Power Capacity (MW)\" IS NOT NULL ORDER BY \"Power Capacity (MW)\" DESC LIMIT 10", "description": "AI supercomputers with the highest power capacity requirements." }, { "query": "SELECT \"GPU Supplier (primary)\", COUNT(*) AS count FROM ai_supercomputers WHERE \"GPU Supplier (primary)\" IS NOT NULL GROUP BY \"GPU Supplier (primary)\" ORDER BY count DESC", "description": "Market share of GPU suppliers in AI supercomputers." }, { "query": "SELECT \"Name\", \"Owner\", \"First Operational Date\", \"Country\" FROM ai_supercomputers WHERE \"First Operational Date\" IS NOT NULL ORDER BY \"First Operational Date\" DESC LIMIT 15", "description": "Most recently operational AI supercomputers with their launch dates." }, { "query": "SELECT \"Single cluster?\", COUNT(*) AS count FROM ai_supercomputers WHERE \"Single cluster?\" IS NOT NULL GROUP BY \"Single cluster?\" ORDER BY count DESC", "description": "How many AI supercomputers are single clusters versus distributed systems." } ] } ```