select count(*),min(time),max(time),sensor_type,json->'sensor_name' as sensor_name from eg5120 group by sensor_type,sensor_name;

