.open ramdisk/aiox.db
.mode list
/*
, 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 max(dt), count(*), systemstatusid    from ir group by systemstatusid limit 3;

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

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

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

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

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

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


