1-- QUERY 2: Automation Risk by Industry
2SELECT 
3  industry,
4  ROUND(AVG(automation_risk_score), 3) as avg_automation_risk,
5  COUNT(*) as job_count,
6  SUM(CASE WHEN ai_mentioned = true THEN 1 ELSE 0 END) as ai_jobs
7FROM "@kdonville.customer_data_1.ai_impact_jobs_2010_2025_csv"
8GROUP BY industry
9ORDER BY avg_automation_risk DESC