1SELECT 
2    COUNT(*) as total_rows,
3    COUNT(DISTINCT series_id) as unique_series,
4    MIN(date) as earliest_date,
5    MAX(date) as latest_date,
6    COUNT(value) as non_null_values,
7    COUNT(value_raw) as non_null_raw_values
8FROM @fred.production_business_activity.observations;