{
    "queries": [
        {
            "query": "SELECT \"Country\", COUNT(*) AS users FROM \"AI_Usage_and_Impact_on_Students_and_Professionals\" GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "Number of survey respondents per country, largest first."
        },
        {
            "query": "SELECT \"User_Type\", AVG(\"Productivity_Score\") AS avg_productivity, AVG(\"Satisfaction_Score\") AS avg_satisfaction FROM \"AI_Usage_and_Impact_on_Students_and_Professionals\" GROUP BY 1 ORDER BY 2 DESC",
            "description": "Average productivity and satisfaction for students versus professionals."
        },
        {
            "query": "SELECT \"Education_Level\", COUNT(*) AS users, AVG(\"Accuracy_Rating\") AS avg_accuracy FROM \"AI_Usage_and_Impact_on_Students_and_Professionals\" WHERE \"Accuracy_Rating\" IS NOT NULL GROUP BY 1 ORDER BY 2 DESC",
            "description": "User counts and average AI accuracy rating by education level."
        },
        {
            "query": "SELECT \"User_ID\", \"Country\", \"Profession\", \"Productivity_Score\", \"Satisfaction_Score\" FROM \"AI_Usage_and_Impact_on_Students_and_Professionals\" WHERE \"Country\" = 'India' AND \"Productivity_Score\" IS NOT NULL ORDER BY \"Productivity_Score\" DESC LIMIT 10",
            "description": "Top 10 Indian respondents ranked by productivity score."
        },
        {
            "query": "SELECT \"Profession\", COUNT(*) AS users, AVG(\"Productivity_Score\") AS avg_productivity FROM \"AI_Usage_and_Impact_on_Students_and_Professionals\" WHERE \"User_Type\" = 'Student' GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "Student majors with the highest average productivity scores."
        },
        {
            "query": "SELECT \"AI_Tool\", COUNT(*) AS users, AVG(\"Satisfaction_Score\") AS avg_satisfaction FROM \"AI_Usage_and_Impact_on_Students_and_Professionals\" GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "Most popular AI tools and how satisfied their users are."
        },
        {
            "query": "SELECT \"AI_Purpose\", COUNT(*) AS users FROM \"AI_Usage_and_Impact_on_Students_and_Professionals\" WHERE \"AI_Purpose\" IS NOT NULL GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "The most common reasons people use AI tools."
        },
        {
            "query": "SELECT \"Would_Recommend\", COUNT(*) AS users, AVG(\"Satisfaction_Score\") AS avg_satisfaction FROM \"AI_Usage_and_Impact_on_Students_and_Professionals\" GROUP BY 1 ORDER BY 2 DESC",
            "description": "How satisfaction differs between those who would and would not recommend AI."
        },
        {
            "query": "SELECT MIN(\"Productivity_Score\") AS min_score, AVG(\"Productivity_Score\") AS avg_score, MAX(\"Productivity_Score\") AS max_score FROM \"AI_Usage_and_Impact_on_Students_and_Professionals\" WHERE \"Productivity_Score\" IS NOT NULL",
            "description": "Lowest, average, and highest productivity scores overall."
        }
    ]
}