MySQL_Scripts/control_total_checks at master · msimonson-psrc/MySQL_Scripts · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
select
year
,count(city_id)
#FROM bazooka_2014.annual_household_control_totals
FROM bazooka_2014.annual_employment_control_totals
group by year
;

SELECT * FROM bazooka_2014.annual_employment_control_totals a;


SELECT
city_id
,year
,sum(total_number_of_households) as hhs
,sum(total_number_of_households * persons_min) as persons
FROM bazooka_2014.annual_household_control_totals
where year in (2017,2020,2025,2030,2035,2040,2045,2050)
group by city_id
,year;


SELECT
city_id
,year
,sum(total_number_of_jobs) as jobs
FROM bazooka_2014.annual_employment_control_totals
where year in (2017,2020,2025,2030,2035,2040,2045,2050)
group by city_id
,year;