rendered paste bodymysql> SELECT date, MAX(outside_temp), MIN(outside_temp) FROM realtime WHERE date > DATE_SUB(NOW(), INTERVAL 1 MONTH) GROUP BY date ORDER BY date DESC;
+------------+-------------------+-------------------+
| date | MAX(outside_temp) | MIN(outside_temp) |
+------------+-------------------+-------------------+
| 2007-11-12 | 21.6 | 21.6 |
| 2007-11-11 | 27.1 | 27.1 |
| 2007-11-10 | 26.8 | 26.8 |
| 2007-11-09 | 25.9 | 25.9 |
| 2007-11-08 | 23.4 | 23.4 |
| 2007-11-07 | 21.6 | 21.6 |
| 2007-11-06 | 21.7 | 21.7 |
| 2007-11-05 | 17.2 | 17.2 |
| 2007-11-04 | 14.7 | 14.7 |
| 2007-11-03 | 20.2 | 20.2 |
| 2007-11-02 | 19.7 | 19.7 |
| 2007-11-01 | 25 | 25 |
| 2007-10-31 | 21.6 | 21.6 |
| 2007-10-30 | 21.2 | 21.2 |
| 2007-10-29 | 20.1 | 20.1 |
| 2007-10-28 | 27.6 | 27.6 |
| 2007-10-27 | 14 | 14 |
| 2007-10-26 | 19.1 | 19.1 |
| 2007-10-25 | 13.6 | 13.6 |
| 2007-10-24 | 19.7 | 19.7 |
| 2007-10-14 | 11.8 | 11.8 |
| 2007-10-13 | 14.8 | 14.8 |
+------------+-------------------+-------------------+
22 rows in set (0.00 sec)
mysql> SELECT date, MAX(outside_temp), MIN(outside_temp) FROM realtime WHERE date > DATE_SUB(NOW(), INTERVAL 1 MONTH) GROUP BY date ORDER BY date ASC;
+------------+-------------------+-------------------+
| date | MAX(outside_temp) | MIN(outside_temp) |
+------------+-------------------+-------------------+
| 2007-10-13 | 14.800000190735 | 7.3000001907349 |
| 2007-10-14 | 11.800000190735 | 11.800000190735 |
| 2007-10-24 | 19.700000762939 | 12 |
| 2007-10-25 | 13.60000038147 | 11.60000038147 |
| 2007-10-26 | 19.10000038147 | 11.60000038147 |
| 2007-10-27 | 14 | 12 |
| 2007-10-28 | 27.60000038147 | 14.300000190735 |
| 2007-10-29 | 20.10000038147 | 12 |
| 2007-10-30 | 21.200000762939 | 10.89999961853 |
| 2007-10-31 | 21.60000038147 | 11.60000038147 |
| 2007-11-01 | 25 | 14 |
| 2007-11-02 | 19.700000762939 | 13.10000038147 |
| 2007-11-03 | 20.200000762939 | 13.199999809265 |
| 2007-11-04 | 14.699999809265 | 10.39999961853 |
| 2007-11-05 | 17.200000762939 | 8.5 |
| 2007-11-06 | 21.700000762939 | 7.5 |
| 2007-11-07 | 21.60000038147 | 9.5 |
| 2007-11-08 | 23.39999961853 | 8.5 |
| 2007-11-09 | 25.89999961853 | 9.8000001907349 |
| 2007-11-10 | 26.799999237061 | 12.39999961853 |
| 2007-11-11 | 27.10000038147 | 12.60000038147 |
| 2007-11-12 | 21.60000038147 | 14.199999809265 |
+------------+-------------------+-------------------+
22 rows in set (0.00 sec)
mysql> SELECT date, MAX(outside_temp), MIN(outside_temp) FROM realtime WHERE date > DATE_SUB(NOW(), INTERVAL 1 MONTH) GROUP BY date;
+------------+-------------------+-------------------+
| date | MAX(outside_temp) | MIN(outside_temp) |
+------------+-------------------+-------------------+
| 2007-10-13 | 14.800000190735 | 7.3000001907349 |
| 2007-10-14 | 11.800000190735 | 11.800000190735 |
| 2007-10-24 | 19.700000762939 | 12 |
| 2007-10-25 | 13.60000038147 | 11.60000038147 |
| 2007-10-26 | 19.10000038147 | 11.60000038147 |
| 2007-10-27 | 14 | 12 |
| 2007-10-28 | 27.60000038147 | 14.300000190735 |
| 2007-10-29 | 20.10000038147 | 12 |
| 2007-10-30 | 21.200000762939 | 10.89999961853 |
| 2007-10-31 | 21.60000038147 | 11.60000038147 |
| 2007-11-01 | 25 | 14 |
| 2007-11-02 | 19.700000762939 | 13.10000038147 |
| 2007-11-03 | 20.200000762939 | 13.199999809265 |
| 2007-11-04 | 14.699999809265 | 10.39999961853 |
| 2007-11-05 | 17.200000762939 | 8.5 |
| 2007-11-06 | 21.700000762939 | 7.5 |
| 2007-11-07 | 21.60000038147 | 9.5 |
| 2007-11-08 | 23.39999961853 | 8.5 |
| 2007-11-09 | 25.89999961853 | 9.8000001907349 |
| 2007-11-10 | 26.799999237061 | 12.39999961853 |
| 2007-11-11 | 27.10000038147 | 12.60000038147 |
| 2007-11-12 | 21.60000038147 | 14.199999809265 |
+------------+-------------------+-------------------+
22 rows in set (0.00 sec)
mysql> SELECT date, MAX(outside_temp), MIN(outside_temp) FROM realtime WHERE date > DATE_SUB(NOW(), INTERVAL 1 MONTH) GROUP BY date ORDER BY MAX(outside_temp);
+------------+-------------------+-------------------+
| date | MAX(outside_temp) | MIN(outside_temp) |
+------------+-------------------+-------------------+
| 2007-10-14 | 11.8 | 11.8 |
| 2007-10-25 | 13.6 | 11.6 |
| 2007-10-27 | 14 | 12 |
| 2007-11-04 | 14.7 | 10.4 |
| 2007-10-13 | 14.8 | 7.3 |
| 2007-11-05 | 17.2 | 8.5 |
| 2007-10-26 | 19.1 | 11.6 |
| 2007-11-02 | 19.7 | 13.1 |
| 2007-10-24 | 19.7 | 12 |
| 2007-10-29 | 20.1 | 12 |
| 2007-11-03 | 20.2 | 13.2 |
| 2007-10-30 | 21.2 | 10.9 |
| 2007-11-07 | 21.6 | 9.5 |
| 2007-10-31 | 21.6 | 11.6 |
| 2007-11-12 | 21.6 | 14.2 |
| 2007-11-06 | 21.7 | 7.5 |
| 2007-11-08 | 23.4 | 8.5 |
| 2007-11-01 | 25 | 14 |
| 2007-11-09 | 25.9 | 9.8 |
| 2007-11-10 | 26.8 | 12.4 |
| 2007-11-11 | 27.1 | 12.6 |
| 2007-10-28 | 27.6 | 14.3 |
+------------+-------------------+-------------------+
22 rows in set (0.00 sec)
--
mysql> SELECT date, MIN(outside_temp) FROM realtime WHERE date > DATE_SUB(NOW(), INTERVAL 1 MONTH) GROUP BY date ORDER BY date DESC;
+------------+-------------------+
| date | MIN(outside_temp) |
+------------+-------------------+
| 2007-11-12 | 14.2 |
| 2007-11-11 | 12.6 |
| 2007-11-10 | 12.4 |
| 2007-11-09 | 9.8 |
| 2007-11-08 | 8.5 |
| 2007-11-07 | 9.5 |
| 2007-11-06 | 7.5 |
| 2007-11-05 | 8.5 |
| 2007-11-04 | 10.4 |
| 2007-11-03 | 13.2 |
| 2007-11-02 | 13.1 |
| 2007-11-01 | 14 |
| 2007-10-31 | 11.6 |
| 2007-10-30 | 10.9 |
| 2007-10-29 | 12 |
| 2007-10-28 | 14.3 |
| 2007-10-27 | 12 |
| 2007-10-26 | 11.6 |
| 2007-10-25 | 11.6 |
| 2007-10-24 | 12 |
| 2007-10-14 | 11.8 |
| 2007-10-13 | 7.3 |
+------------+-------------------+
22 rows in set (0.00 sec)
mysql> SELECT date, AVG(outside_temp), MIN(outside_temp) FROM realtime WHERE date > DATE_SUB(NOW(), INTERVAL 1 MONTH) GROUP BY date ORDER BY date DESC;
+------------+-------------------+-------------------+
| date | AVG(outside_temp) | MIN(outside_temp) |
+------------+-------------------+-------------------+
| 2007-11-12 | 16.74328068671 | 14.199999809265 |
| 2007-11-11 | 18.980685014855 | 12.60000038147 |
| 2007-11-10 | 19.756192255375 | 12.39999961853 |
| 2007-11-09 | 17.673192556125 | 9.8000001907349 |
| 2007-11-08 | 15.777354491087 | 8.5 |
| 2007-11-07 | 15.370581322524 | 9.5 |
| 2007-11-06 | 14.110634097462 | 7.5 |
| 2007-11-05 | 12.578441115117 | 8.5 |
| 2007-11-04 | 12.301248365927 | 10.39999961853 |
| 2007-11-03 | 15.878865421901 | 13.199999809265 |
| 2007-11-02 | 15.456385804312 | 13.10000038147 |
| 2007-11-01 | 18.553382470027 | 14 |
| 2007-10-31 | 15.541578214913 | 11.60000038147 |
| 2007-10-30 | 15.558676165951 | 10.89999961853 |
| 2007-10-29 | 16.021715010932 | 12 |
| 2007-10-28 | 23.837111851847 | 14.300000190735 |
| 2007-10-27 | 12.86172215002 | 12 |
| 2007-10-26 | 14.105214550733 | 11.60000038147 |
| 2007-10-25 | 12.319123867104 | 11.60000038147 |
| 2007-10-24 | 14.649579545542 | 12 |
| 2007-10-14 | 11.800000190735 | 11.800000190735 |
| 2007-10-13 | 11.157914141913 | 7.3000001907349 |
+------------+-------------------+-------------------+
22 rows in set (0.36 sec)
mysql> SELECT date, AVG(outside_temp), MAX(outside_temp) FROM realtime WHERE date > DATE_SUB(NOW(), INTERVAL 1 MONTH) GROUP BY date ORDER BY date DESC;
+------------+-------------------+-------------------+
| date | AVG(outside_temp) | MAX(outside_temp) |
+------------+-------------------+-------------------+
| 2007-11-12 | 16.777475219568 | 21.60000038147 |
| 2007-11-11 | 18.980685014855 | 27.10000038147 |
| 2007-11-10 | 19.756192255375 | 26.799999237061 |
| 2007-11-09 | 17.673192556125 | 25.89999961853 |
| 2007-11-08 | 15.777354491087 | 23.39999961853 |
| 2007-11-07 | 15.370581322524 | 21.60000038147 |
| 2007-11-06 | 14.110634097462 | 21.700000762939 |
| 2007-11-05 | 12.578441115117 | 17.200000762939 |
| 2007-11-04 | 12.301248365927 | 14.699999809265 |
| 2007-11-03 | 15.878865421901 | 20.200000762939 |
| 2007-11-02 | 15.456385804312 | 19.700000762939 |
| 2007-11-01 | 18.553382470027 | 25 |
| 2007-10-31 | 15.541578214913 | 21.60000038147 |
| 2007-10-30 | 15.558676165951 | 21.200000762939 |
| 2007-10-29 | 16.021715010932 | 20.10000038147 |
| 2007-10-28 | 23.837111851847 | 27.60000038147 |
| 2007-10-27 | 12.86172215002 | 14 |
| 2007-10-26 | 14.105214550733 | 19.10000038147 |
| 2007-10-25 | 12.319123867104 | 13.60000038147 |
| 2007-10-24 | 14.649579545542 | 19.700000762939 |
| 2007-10-14 | 11.800000190735 | 11.800000190735 |
| 2007-10-13 | 11.157914141913 | 14.800000190735 |
+------------+-------------------+-------------------+
22 rows in set (0.36 sec)
mysql> SELECT date, AVG(outside_temp), MIN(outside_temp), MAX(outside_temp) FROM realtime WHERE date > DATE_SUB(NOW(), INTERVAL 1 MONTH) GROUP BY date ORDER BY date DESC;
+------------+-------------------+-------------------+-------------------+
| date | AVG(outside_temp) | MIN(outside_temp) | MAX(outside_temp) |
+------------+-------------------+-------------------+-------------------+
| 2007-11-12 | 16.778820275415 | 14.199999809265 | 21.60000038147 |
| 2007-11-11 | 18.980685014855 | 12.60000038147 | 27.10000038147 |
| 2007-11-10 | 19.756192255375 | 12.39999961853 | 26.799999237061 |
| 2007-11-09 | 17.673192556125 | 9.8000001907349 | 25.89999961853 |
| 2007-11-08 | 15.777354491087 | 8.5 | 23.39999961853 |
| 2007-11-07 | 15.370581322524 | 9.5 | 21.60000038147 |
| 2007-11-06 | 14.110634097462 | 7.5 | 21.700000762939 |
| 2007-11-05 | 12.578441115117 | 8.5 | 17.200000762939 |
| 2007-11-04 | 12.301248365927 | 10.39999961853 | 14.699999809265 |
| 2007-11-03 | 15.878865421901 | 13.199999809265 | 20.200000762939 |
| 2007-11-02 | 15.456385804312 | 13.10000038147 | 19.700000762939 |
| 2007-11-01 | 18.553382470027 | 14 | 25 |
| 2007-10-31 | 15.541578214913 | 11.60000038147 | 21.60000038147 |
| 2007-10-30 | 15.558676165951 | 10.89999961853 | 21.200000762939 |
| 2007-10-29 | 16.021715010932 | 12 | 20.10000038147 |
| 2007-10-28 | 23.837111851847 | 14.300000190735 | 27.60000038147 |
| 2007-10-27 | 12.86172215002 | 12 | 14 |
| 2007-10-26 | 14.105214550733 | 11.60000038147 | 19.10000038147 |
| 2007-10-25 | 12.319123867104 | 11.60000038147 | 13.60000038147 |
| 2007-10-24 | 14.649579545542 | 12 | 19.700000762939 |
| 2007-10-14 | 11.800000190735 | 11.800000190735 | 11.800000190735 |
| 2007-10-13 | 11.157914141913 | 7.3000001907349 | 14.800000190735 |
+------------+-------------------+-------------------+-------------------+
22 rows in set (0.37 sec)