1SELECT 
2    EXTRACT(YEAR FROM o.date) || '-' || EXTRACT(QUARTER FROM o.date) as year_quarter,
3    avg(o.value) as uncertainty_index
4FROM "@fred.academic_data.observations" o
5     INNER JOIN "@fred.academic_data.series" s ON o.series_id = s.series_id
6WHERE s.series_id = 'WUIGLOBALWEIGHTAVG' -- World Uncertainty Index
7  AND o.date >= '2000-01-01'
8GROUP BY ALL
9ORDER BY 1