1. Top 10 industries by AI & LLM market size
SELECT industry, SUM(market_size) AS total_market_size
FROM ai_llm_impact
GROUP BY industry
ORDER BY total_market_size DESC
LIMIT 10;

-- 2. Year-over-year growth rate of AI & LLM market
SELECT 
    year,
    market_size,
    (market_size - LAG(market_size, 1) OVER (ORDER BY year)) / LAG(market_size, 1) OVER (ORDER BY year) AS yoy_growth_rate
FROM 
    ai_llm_impact
GROUP BY
    year, market_size
ORDER BY
    year;

-- 3. AI & LLM technologies with adoption rate > 50%
SELECT technology, adoption_rate
FROM ai_llm_impact
WHERE adoption_rate > 0.5
GROUP BY technology, adoption_rate;

-- 4. Business productivity metrics with highest impact
SELECT metric, MAX(impact) AS max_impact
FROM business_productivity
GROUP BY metric
ORDER BY max_impact DESC
LIMIT 5;

-- 5. Total cost savings from AI & LLM adoption
SELECT SUM(cost_savings) AS total_cost_savings
FROM business_productivity;

-- 6. Companies with highest decision-making improvement
SELECT company, decision_making_improvement
FROM business_productivity
ORDER BY decision_making_improvement DESC
LIMIT 10;

-- 7. Top 5 job types with highest new job creation
SELECT job_type, SUM(new_jobs) AS total_new_jobs
FROM job_opportunities
GROUP BY job_type
ORDER BY total_new_jobs DESC
LIMIT 5;

-- 8. Skills with highest demand for AI & LLM jobs
SELECT skill, SUM(required_skills) AS total_required
FROM job_opportunities
GROUP BY skill
ORDER BY total_required DESC
LIMIT 10;

-- 9. Industries with highest job displacement
SELECT industry, SUM(job_displacement) AS total_displacement
FROM job_opportunities
GROUP BY industry
ORDER BY total_displacement DESC
LIMIT 5;

-- 10. Forecasted AI & LLM market size for next 5 years 
SELECT year, forecast_market_size
FROM ai_llm_impact_forecast
WHERE year BETWEEN YEAR(CURRENT_DATE) AND YEAR(CURRENT_DATE) + 4
ORDER BY year;

-- 11. Emerging AI & LLM technologies description
SELECT technology, description 
FROM ai_llm_technologies
ORDER BY technology;

-- 12. Best practices with highest impact
SELECT best_practice, MAX(impact) AS max_impact
FROM ai_llm_best_practices
GROUP BY best_practice
ORDER BY max_impact DESC
LIMIT 5;

-- 13. Companies with most AI & LLM success stories
SELECT company_name, COUNT(*) AS num_success_stories
FROM ai_llm_case_studies
GROUP BY company_name
ORDER BY num_success_stories DESC
LIMIT 10;

-- 14. Market share of top 10 AI & LLM industry leaders
SELECT company_name, industry, market_share
FROM ai_llm_industry_leaders
ORDER BY market_share DESC
LIMIT 10;

-- 15. Emerging trends with highest potential impact
SELECT trend, MAX(potential_impact) AS max_potential_impact
FROM ai_llm_trends
GROUP BY trend
ORDER BY max_potential_impact DESC
LIMIT 5;

-- 16. AI & LLM adoption timeline by industry
SELECT industry, MIN(adoption_year) AS first_adoption_year
FROM industry_adoption
GROUP BY industry
ORDER BY first_adoption_year;

-- 17. Regulatory landscape for AI & LLM by country
SELECT country, regulation_status, regulation_details
FROM regulations
ORDER BY country;

-- 18. AI & LLM risk factors by category 
SELECT risk_category, risk_factor, mitigation_strategy
FROM risk_factors
ORDER BY risk_category, risk_factor;

-- 19. AI & LLM research funding by source
SELECT funding_source, SUM(funding_amount) AS total_funding
FROM research_funding  
GROUP BY funding_source
ORDER BY total_funding DESC;

-- 20. AI & LLM patent filings by company
SELECT company, COUNT(*) AS num_patents
FROM patents
GROUP BY company
ORDER BY num_patents DESC
LIMIT 10;