select * from demo_db.fire_service_calls_tbl limit 100

drop view if exists fire_service_calls_tbl_cache;

cache lazy table fire_service_calls_tbl_cache as

select * from demo_db.fire_service_calls_tbl

select count(*) from demo_db.fire_service_calls_tbl

select count(distinct callType) as distinct_call_type_count

from demo_db.fire_service_calls_tbl

where callType is not null

select distinct callType as distinct_call_types

from demo_db.fire_service_calls_tbl

where callType is not null

select callNumber, Delay

from demo_db.fire_service_calls_tbl

where Delay > 5

select callType, count(*) as count

from demo_db.fire_service_calls_tbl

where callType is not null

group by callType

order by count desc

select callType, zipCode, count(*) as count

from demo_db.fire_service_calls_tbl

where callType is not null

group by callType, zipCode

order by count desc

select zipCode, neighborhood

from demo_db.fire_service_calls_tbl

where zipCode == 94102 or zipCode == 94103

select sum(NumAlarms), avg(Delay), min(Delay), max(Delay)

from demo_db.fire_service_calls_tbl

select distinct year(to_date(callDate, "MM/dd/yyyy")) as year_num

from demo_db.fire_service_calls_tbl

order by year_num

select weekofyear(to_date(callDate, "MM/dd/yyyy")) week_year, count(*) as count

from demo_db.fire_service_calls_tbl

where year(to_date(callDate, "MM/dd/yyyy")) == 2018

group by week_year

order by count desc

select neighborhood, delay

from demo_db.fire_service_calls_tbl

where year(to_date(callDate, "MM/dd/yyyy")) == 2018

order by delay desc