```json { "queries": [ { "query": "SELECT job_title, COUNT(*) AS job_count FROM ai_job_dataset GROUP BY job_title ORDER BY job_count DESC LIMIT 10", "description": "Top 10 most common AI job titles in the dataset." }, { "query": "SELECT company_location, COUNT(*) AS listings FROM ai_job_dataset GROUP BY company_location ORDER BY listings DESC LIMIT 15", "description": "Countries with the most AI job postings." }, { "query": "SELECT experience_level, COUNT(*) AS count FROM ai_job_dataset WHERE experience_level IS NOT NULL GROUP BY experience_level ORDER BY count DESC", "description": "Distribution of jobs by experience level requirement." }, { "query": "SELECT employment_type, COUNT(*) AS total FROM ai_job_dataset WHERE employment_type IS NOT NULL GROUP BY employment_type ORDER BY total DESC", "description": "Breakdown of AI jobs by employment type (full-time, part-time, contract)." }, { "query": "SELECT company_size, COUNT(*) AS jobs FROM ai_job_dataset WHERE company_size IS NOT NULL GROUP BY company_size ORDER BY jobs DESC", "description": "Number of AI job postings by company size category." }, { "query": "SELECT remote_ratio, COUNT(*) AS positions FROM ai_job_dataset WHERE remote_ratio IS NOT NULL GROUP BY remote_ratio ORDER BY positions DESC", "description": "Distribution of jobs by remote work ratio." }, { "query": "SELECT industry, COUNT(*) AS openings FROM ai_job_dataset WHERE industry IS NOT NULL GROUP BY industry ORDER BY openings DESC LIMIT 12", "description": "Top industries hiring for AI positions." }, { "query": "SELECT education_required, COUNT(*) AS count FROM ai_job_dataset WHERE education_required IS NOT NULL GROUP BY education_required ORDER BY count DESC", "description": "Education requirements for AI jobs in the market." }, { "query": "SELECT salary_currency, COUNT(*) AS listings FROM ai_job_dataset WHERE salary_currency IS NOT NULL GROUP BY salary_currency ORDER BY listings DESC LIMIT 10", "description": "Most common currencies used for AI job salary postings." }, { "query": "SELECT job_title, company_location, employment_type FROM ai_job_dataset WHERE job_title IS NOT NULL LIMIT 20", "description": "Sample of AI job listings with title, location, and employment type." } ] } ```