mysql> create temporary table rep select node_mac, node_ip, avg(snr) as avg, stddev(snr) as stddev, count(*) as count from reports group by node_mac; mysql> select * from rep order by 4; +-------------------+---------------+---------+--------+-------+ | node_mac | node_ip | avg | stddev | count | +-------------------+---------------+---------+--------+-------+ | 00:0B:6B:33:62:A8 | 192.168.1.183 | 0.0012 | 0.1455 | 15301 | | 00:0B:6B:33:68:0B | 192.168.1.183 | 5.0638 | 0.6546 | 15308 | | 00:0B:6B:33:62:5B | 192.168.1.189 | 26.6779 | 0.8455 | 16132 | | 00:0F:66:56:E4:F9 | 192.168.1.4 | -7.1848 | 0.8502 | 16129 | | 00:11:F5:7D:1C:C4 | 192.168.1.181 | 28.5556 | 0.9314 | 16030 | | 00:0B:6B:56:FE:B3 | 192.168.1.188 | 20.0559 | 1.3559 | 15977 | | 00:16:B6:B1:0A:33 | 192.168.1.171 | 17.7203 | 1.7348 | 16124 | | 00:1C:10:36:3A:A4 | 192.168.1.66 | 25.6646 | 1.8816 | 16004 | | 00:1A:70:5F:30:E2 | 192.168.1.110 | 11.3170 | 1.9113 | 1470 | | 00:14:BF:BD:60:E9 | 192.168.1.139 | 7.3747 | 2.1674 | 15793 | | 00:12:17:CC:03:84 | 192.168.1.103 | 6.1653 | 2.1788 | 16122 | | 00:1C:10:09:01:05 | 192.168.1.124 | 14.1044 | 2.4725 | 16130 | | 00:18:39:D3:F9:A5 | 192.168.1.164 | 6.7157 | 2.6530 | 1720 | | 00:14:BF:C4:BA:47 | 192.168.1.83 | 3.3872 | 2.6817 | 14059 | | 00:14:BF:3D:46:07 | 192.168.1.104 | 8.1306 | 2.7856 | 16134 | | 00:13:D4:0F:FE:C1 | 192.168.1.76 | 12.3227 | 2.8927 | 2699 | | 00:11:F5:7F:33:44 | 192.168.1.181 | 22.0799 | 3.2071 | 16008 | | 00:18:39:D4:99:68 | 192.168.1.52 | 16.2194 | 3.2185 | 16032 | | 00:18:39:D3:D1:A9 | 192.168.1.5 | 9.4709 | 3.3429 | 16105 | | 00:0F:66:C8:5F:4F | 192.168.1.39 | 6.3917 | 3.4468 | 15360 | | 00:0F:66:56:E1:C0 | 192.168.1.167 | 8.2723 | 3.5034 | 15978 | | 00:16:B6:A3:EA:D1 | 192.168.1.129 | 15.5111 | 3.5081 | 16129 | | 00:0F:66:97:D2:BA | 192.168.1.25 | 6.1830 | 3.5279 | 16128 | | 00:14:BF:BD:66:0B | 192.168.1.172 | 14.2416 | 3.5329 | 16128 | | 00:0B:6B:33:69:6F | 192.168.1.183 | 34.7050 | 3.5550 | 15274 | | 00:14:BF:3D:54:E6 | 192.168.1.105 | 15.4516 | 3.6223 | 16026 | | 00:14:BF:16:AF:9E | 192.168.1.69 | 11.3145 | 3.6551 | 15913 | | 00:0E:A6:B7:DF:A6 | 192.168.1.16 | 12.5566 | 3.7397 | 16125 | | 00:1C:10:09:01:44 | 192.168.1.175 | 11.6002 | 3.9544 | 15974 | | 00:14:BF:3D:54:EF | 192.168.1.99 | 12.1266 | 4.0274 | 13671 | | 00:0E:A6:90:7D:52 | 192.168.1.15 | 14.5317 | 4.7364 | 16134 | | 00:14:BF:A2:64:67 | 192.168.1.75 | 14.2360 | 5.1876 | 16073 | | 00:0B:6B:33:61:C8 | 192.168.1.189 | 25.9371 | 5.2757 | 15711 | | 00:0E:A6:F0:4A:F5 | 192.168.1.14 | 16.8366 | 5.8628 | 16068 | | 00:14:BF:BD:68:B7 | 192.168.1.170 | 19.8358 | 6.4649 | 15930 | | 00:0B:6B:57:ED:A6 | 192.168.1.188 | 41.1508 | 9.7202 | 15945 | +-------------------+---------------+---------+--------+-------+ mysql> select mod(ahour, 24) as dhour, avg(snr), stddev(snr) from reports group by dhour; +-------+----------+-------------+ | dhour | avg(snr) | stddev(snr) | +-------+----------+-------------+ | 0 | 14.6099 | 10.4131 | | 1 | 14.6124 | 10.4206 | | 2 | 14.6095 | 10.3956 | | 3 | 14.6023 | 10.4019 | | 4 | 14.6577 | 10.3840 | | 5 | 14.6403 | 10.3925 | | 6 | 14.7358 | 10.3708 | | 7 | 14.7328 | 10.3583 | | 8 | 14.7903 | 10.3814 | | 9 | 14.7686 | 10.4164 | | 10 | 14.7939 | 10.3789 | | 11 | 14.7347 | 10.3908 | | 12 | 14.6805 | 10.3249 | | 13 | 14.6553 | 10.3473 | | 14 | 14.6836 | 10.3640 | | 15 | 14.7246 | 10.3783 | | 16 | 14.7542 | 10.3779 | | 17 | 14.6723 | 10.4123 | | 18 | 14.7106 | 10.3642 | | 19 | 14.6508 | 10.3535 | | 20 | 14.6678 | 10.4234 | | 21 | 14.6510 | 10.4496 | | 22 | 14.6530 | 10.4356 | | 23 | 14.6311 | 10.4684 | +-------+----------+-------------+ 24 rows in set (0.00 sec) mysql> select weekday(time), avg(snr) from reports group by 1; +---------------+----------+ | weekday(time) | avg(snr) | +---------------+----------+ | 0 | 14.8985 | | 1 | 14.7237 | | 2 | 14.6150 | | 3 | 14.4687 | | 4 | 14.5637 | | 5 | 14.7274 | | 6 | 14.7972 | +---------------+----------+ 7 rows in set (1.26 sec)