.open aiox.db
.mode list
/*
finds the time of day that the today kwhs are reset to zero
, Epv1_total num    --50,51 0.1kWh
, Eac_chrToday num    --56-57 0.1kWh
, Eac_chrTotal num    --58-59 0.1kWh
, Ebat_dischrToday num    --60,61 0.1kWh
, Ebat_dischrTotal num    --62,63 0.1kWh
, Eac_dischrToday num    --64-65 0.1kWh
, Eac_dischrTotal num    --66-67 0.1kWh
, Bat_Watt num          --77 0.1W
, Eop_dischrToday num    --85-86 0.1kWh
, Eop_dischrTotal num    --87-88 0.1kWh
*/
--select min(dt), max(dt), count(*), systemstatusid    from ir group by systemstatusid limit 3;

--select min(dt), max(dt), count(*), BatVolt           from ir group by BatVolt limit 3;

select min(dt), max(dt), count(*), Epv1_Today        from ir group by Epv1_Today limit 3;

select min(dt), max(dt), count(*), Eac_chrToday      from ir group by Eac_chrToday limit 3;

select min(dt), max(dt), count(*), Eac_dischrToday   from ir group by Eac_dischrToday limit 3;

select min(dt), max(dt), count(*), Ebat_dischrToday   from ir group by Ebat_dischrToday limit 3;

select min(dt), max(dt), count(*), Eop_dischrToday   from ir group by Eop_dischrToday limit 3;


