{
    "queries": [
        {
            "query": "SELECT \"City  Location\", COUNT(*) AS deals FROM startup_funding WHERE \"City  Location\" IS NOT NULL AND \"City  Location\" <> 'nan' GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "Cities with the most funding deals, busiest first."
        },
        {
            "query": "SELECT \"Industry Vertical\", COUNT(*) AS deals FROM startup_funding WHERE \"Industry Vertical\" IS NOT NULL AND \"Industry Vertical\" <> 'nan' GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "Industry verticals receiving the most funding deals."
        },
        {
            "query": "SELECT \"InvestmentnType\", COUNT(*) AS deals FROM startup_funding WHERE \"InvestmentnType\" IS NOT NULL GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "Most common investment types across all deals."
        },
        {
            "query": "SELECT \"Startup Name\", \"Date dd/mm/yyyy\", \"Investors Name\", \"Amount in USD\" FROM startup_funding WHERE \"Startup Name\" = 'Swiggy' LIMIT 10",
            "description": "Funding rounds recorded for Swiggy."
        },
        {
            "query": "SELECT \"Startup Name\", COUNT(*) AS rounds FROM startup_funding WHERE \"Startup Name\" IS NOT NULL GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "Startups that appear in the most funding rounds."
        },
        {
            "query": "SELECT \"Startup Name\", \"City  Location\", \"Amount in USD\" FROM startup_funding WHERE \"Amount in USD\" IS NOT NULL AND \"Amount in USD\" <> 'N/A' AND \"City  Location\" = 'Bangalore' LIMIT 10",
            "description": "Sample of Bangalore startup deals with disclosed amounts."
        },
        {
            "query": "SELECT \"Startup Name\", \"Investors Name\", \"Amount in USD\" FROM startup_funding WHERE \"Investors Name\" = 'Ratan Tata' LIMIT 10",
            "description": "Startups backed by Ratan Tata and the amounts raised."
        },
        {
            "query": "SELECT SUM(TRY_CAST(REPLACE(\"Amount in USD\", ',', '') AS DOUBLE)) AS total_usd, AVG(TRY_CAST(REPLACE(\"Amount in USD\", ',', '') AS DOUBLE)) AS avg_usd FROM startup_funding",
            "description": "Total and average disclosed funding amount in USD."
        },
        {
            "query": "SELECT \"SubVertical\", COUNT(*) AS deals FROM startup_funding WHERE \"SubVertical\" IS NOT NULL AND \"SubVertical\" <> 'nan' GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "Most funded sub-verticals by number of deals."
        }
    ]
}