show by type and mac

[eg5120] / queries.sql

diff --git a/queries.sql b/queries.sql
index 221cbbe..216f518 100644 (file)
--- a/queries.sql
+++ b/queries.sql
@@ -1,2 +1,12 @@
-select count(*),min(time),max(time),sensor_type,json->'sensor_name' as sensor_name from eg5120 group by sensor_type,sensor_name;
+select count(*),min(time),max(time),
+sensor_type,
+addr as mac,
+json->'sensor_name' as sensor_name
+from eg5120
+group by 
+sensor_type,
+addr,
+sensor_name
+order by sensor_type asc, max desc
+;