1-- QUERY 1: AI Adoption Over Time (2010–2025)
2SELECT 
3  posting_year,
4  COUNT(*) as total_jobs,
5  SUM(CASE WHEN ai_mentioned = true THEN 1 ELSE 0 END) as ai_jobs,
6  ROUND(AVG(ai_intensity_score), 3) as avg_ai_intensity
7FROM "@kdonville.customer_data_1.ai_impact_jobs_2010_2025_csv"
8GROUP BY posting_year
9ORDER BY posting_year ASC
10