Esper-deduce-status-by-place.md

create window HallTemperatureStatus.win:length(1) as (status string);

insert into HallTemperatureStatus select 'warning' as status from HallTemperature(temperature > 18 and temperature <=22);
insert into HallTemperatureStatus select 'alert' as status from HallTemperature(temperature <= 18);
insert into HallTemperatureStatus select 'ok' as status from HallTemperature(temperature > 22);

create window BedroomTemperatureStatus.win:length(1) as (status string) ;

insert into BedroomTemperatureStatus select 'warning' as status from BedroomTemperature(temperature > 18 and temperature <=22);
insert into BedroomTemperatureStatus select 'alert' as status from BedroomTemperature(temperature <= 18);
insert into BedroomTemperatureStatus select 'ok' as status from BedroomTemperature(temperature > 22);