select avg(temperature), month(mdate) from METEO group by month(mdate) order by month(mdate);
+--------------------+--------------+
| avg(temperature)   | month(mdate) |
+--------------------+--------------+
|  2.362466276238643 |            1 |
|  7.873496049953813 |            2 |
| 11.840677227576967 |            3 |
| 14.992254975310312 |            4 |
|  19.68453711556556 |            5 |
| 25.858309613866332 |            6 |
| 28.634881911114565 |            7 |
| 28.850474397804028 |            8 |
| 20.895183591767093 |            9 |
| 15.274819292770648 |           10 |
|  9.610323779829676 |           11 |
|  6.903833698030965 |           12 |
+--------------------+--------------+
12 rows in set (0,30 sec)

 select avg(temperature),month(mdate) from METEO group by month(mdate) order by avg(temperature);
+--------------------+--------------+
| avg(temperature)   | month(mdate) |
+--------------------+--------------+
|  2.362466276238643 |            1 |
|  6.903833698030965 |           12 |
|  7.873496049953813 |            2 |
|  9.610323779829676 |           11 |
| 11.840677227576967 |            3 |
| 14.992254975310312 |            4 |
| 15.274819292770648 |           10 |
|  19.68453711556556 |            5 |
| 20.895183591767093 |            9 |
| 25.858309613866332 |            6 |
| 28.634881911114565 |            7 |
| 28.850474397804028 |            8 |
+--------------------+--------------+
12 rows in set (0,30 sec)

 select max(temperature),avg(temperature),min(temperature),month(mdate) from METEO group by month(mdate) order by month(mdate);
+------------------+--------------------+------------------+--------------+
| max(temperature) | avg(temperature)   | min(temperature) | month(mdate) |
+------------------+--------------------+------------------+--------------+
| 9.81             |  2.362466276238643 | -1.2             |            1 |
| 9.81             |  7.873496049953813 | -1.2             |            2 |
| 9.81             | 11.840677227576967 | 1.96             |            3 |
| 9.81             | 14.992254975310312 | 1.40             |            4 |
| 9.81             |  19.68453711556556 | 10.0             |            5 |
| 44.76            | 25.858309613866332 | 12.61            |            6 |
| 46.82            | 28.634881911114565 | 14.67            |            7 |
| 47.38            | 28.850474397804028 | 15.60            |            8 |
| 9.81             | 20.895183591767093 | 10.0             |            9 |
| 9.81             | 15.274819292770648 | 10.0             |           10 |
| 9.81             |  9.610323779829676 | -1.2             |           11 |
| 9.81             |  6.903833698030965 | -1.2             |           12 |
+------------------+--------------------+------------------+--------------+
12 rows in set (0,39 sec)

 select count(temperature),month(mdate) from METEO group by month(mdate) having count(temperature)>0.25*avg(temperature) order by month(mdate);
+--------------------+--------------+
| count(temperature) | month(mdate) |
+--------------------+--------------+
|              30394 |            1 |
|              28987 |            2 |
|              27081 |            3 |
|              40098 |            4 |
|              44806 |            5 |
|              36749 |            6 |
|              36879 |            7 |
|              35329 |            8 |
|              33471 |            9 |
|              23076 |           10 |
|              16678 |           11 |
|              34275 |           12 |
+--------------------+--------------+
12 rows in set (0,31 sec)

 select avg(temperature),month(mdate) from METEO where (temperature>35 or temperature<0) group by month(mdate) order by month(mdate);
+---------------------+--------------+
| avg(temperature)    | month(mdate) |
+---------------------+--------------+
|  -3.763642509464485 |            1 |
| -1.5443265306122405 |            2 |
|  35.673124999999985 |            4 |
|    35.5827450980392 |            5 |
|   38.11119110260694 |            6 |
|   39.07182697474389 |            7 |
|   38.77071585903058 |            8 |
|  37.497499999999874 |            9 |
| -1.3398888888888887 |           11 |
|   -2.08990109890112 |           12 |
+---------------------+--------------+
10 rows in set (0,24 sec)

select count(distinct temperature) from METEO;
+-----------------------------+
| count(distinct temperature) |
+-----------------------------+
|                         302 |
+-----------------------------+
1 row in set (0,49 sec)

select cast(humidity as unsigned int) from METEO limit 1;
+--------------------------------+
| cast(humidity as unsigned int) |
+--------------------------------+
|                             69 |
+--------------------------------+
1 row in set, 1 warning (0,00 sec)

select avg(temperature),month(mdate) from METEO where (humidity<50 and wind_count>20) group by month(mdate) order by month(mdate);
+--------------------+--------------+
| avg(temperature)   | month(mdate) |
+--------------------+--------------+
|   7.61681818181818 |            1 |
| 11.973602484472034 |            2 |
| 11.479982886480288 |            3 |
| 11.864968253968238 |            4 |
| 13.471188118811884 |            5 |
| 15.610000000000001 |            6 |
| 15.232857142857146 |            7 |
|              12.99 |            9 |
| 11.622512562814046 |           10 |
| 12.043245125348173 |           11 |
|  8.669365904365883 |           12 |
+--------------------+--------------+
11 rows in set (0,24 sec)

select count(distinct wind_direction) from METEO;
+--------------------------------+
| count(distinct wind_direction) |
+--------------------------------+
|                            214 |
+--------------------------------+
1 row in set (0,43 sec)

 select max(rain_count),month(mdate) from METEO where rain_count>0 group by month(mdate) order by max(rain_count);
+-----------------+--------------+
| max(rain_count) | month(mdate) |
+-----------------+--------------+
| 1.676           |            8 |
| 3.911           |            9 |
| 4.190           |            7 |
| 4.470           |            5 |
| 7.823           |            6 |
| 8.940           |            4 |
| 85.496          |           10 |
| 9.778           |            1 |
| 9.778           |           12 |
| 9.778           |            2 |
| 9.778           |            3 |
| 9.778           |           11 |
+-----------------+--------------+
12 rows in set (0,19 sec)


 select distinct dewpoint from METEO where (dewpoint<0 or dewpoint>99);
+----------+
| dewpoint |
+----------+
| -5.9     |
| -5.27    |
| -4.91    |
| -4.73    |
| -4.55    |
| -4.37    |
| -5.82    |
| -6.18    |
| -6.0     |
| -6.35    |
| -5.65    |
| -5.47    |
| -5.29    |
| -5.11    |
| -4.19    |
| -5.45    |
| -5.63    |
| -5.81    |
| -5.99    |
| -6.17    |
| -6.53    |
| -4.74    |
| -4.92    |
| -5.10    |
| -5.28    |
| -5.46    |
| -5.64    |
| -5.83    |
| -6.1     |
| -6.19    |
| -6.37    |
| -6.55    |
| -6.74    |
| -6.92    |
| -7.10    |
| -7.28    |
| -7.46    |
| -7.65    |
| -7.83    |
| -8.1     |
| -8.19    |
| -8.37    |
| -8.56    |
| -8.74    |
| -8.92    |
| -9.10    |
| -9.28    |
| -9.47    |
| -9.65    |
| -9.83    |
| -10.19   |
| -10.1    |
| -10.38   |
| -10.56   |
| -10.92   |
| -10.74   |
| -11.10   |
| -11.29   |
| -11.47   |
| -11.65   |
| -11.83   |
| -12.1    |
| -12.20   |
| -12.38   |
| -12.56   |
| -4.1     |
| -6.71    |
| -4.94    |
| -4.76    |
| -4.58    |
| -4.41    |
| -4.5     |
| -4.23    |
| -3.88    |
| -3.70    |
| -5.56    |
| -5.21    |
| -5.39    |
| -5.74    |
| -6.8     |
| -5.91    |
| -6.26    |
| -5.4     |
| -3.84    |
| -3.30    |
| -3.48    |
| -3.12    |
| -3.66    |
| -2.94    |
| -2.76    |
| -2.58    |
| -2.40    |
| -2.22    |
| -2.4     |
| -3.52    |
| -2.55    |
| -3.83    |
| -3.64    |
| -3.28    |
| -3.46    |
| -3.10    |
| -2.92    |
| -3.35    |
| -3.17    |
| -2.99    |
| -2.81    |
| -2.64    |
| -2.46    |
| -2.28    |
| -2.11    |
| -1.93    |
| -3.82    |
| -3.65    |
| -3.47    |
| -4.0     |
| -1.75    |
| -4.17    |
| -3.13    |
| -2.95    |
| -2.78    |
| -2.43    |
| -2.60    |
| -2.8     |
| -4.57    |
| -4.40    |
| -4.6     |
| -3.89    |
| -3.72    |
| -3.55    |
| -3.38    |
| -3.4     |
| -3.21    |
| -2.87    |
| -2.70    |
| -2.53    |
| -2.36    |
| -2.19    |
| -2.2     |
| -1.85    |
| -1.68    |
| -1.51    |
| -1.34    |
| -2.26    |
| -1.91    |
| -4.75    |
| -2.73    |
| -3.25    |
| -3.44    |
| -3.62    |
| -3.80    |
| -3.99    |
| -1.73    |
| -1.56    |
| -1.39    |
| -1.4     |
| -1.22    |
| -1.5     |
| -1.21    |
| -1.40    |
| -1.86    |
| -1.28    |
| -1.10    |
| -1.50    |
| -1.32    |
| -1.14    |
| -1.58    |
| -1.17    |
| -1.0     |
| -2.1     |
| -4.88    |
| -4.71    |
| -4.54    |
| -4.38    |
| -4.21    |
| -4.4     |
| -3.54    |
| -3.71    |
| -3.5     |
| -2.88    |
| -5.37    |
| -6.54    |
| -6.21    |
| -5.89    |
| -5.73    |
| -5.57    |
| -5.40    |
| -5.24    |
| -5.8     |
| -6.5     |
| -6.86    |
| -6.70    |
| -2.71    |
| -2.38    |
| -1.88    |
| -1.72    |
| -2.5     |
| -2.37    |
| -4.35    |
| -3.7     |
| -1.55    |
| -1.38    |
| -4.60    |
| -4.44    |
| -4.27    |
| -4.11    |
| -3.95    |
| -3.79    |
| -3.63    |
| -3.31    |
| -3.15    |
| -2.98    |
| -2.66    |
| -2.50    |
| -7.62    |
| -7.31    |
| -7.16    |
| -7.0     |
| -6.69    |
| -6.39    |
| -6.23    |
| -6.85    |
| -7.47    |
| -7.93    |
| -7.78    |
| -2.82    |
| -5.54    |
| -2.18    |
| -2.34    |
| -10.9    |
| -9.94    |
| -9.63    |
| -9.78    |
| -9.32    |
| -9.17    |
| -8.70    |
| -8.24    |
| -8.55    |
| -8.39    |
| -8.8     |
| -14.91   |
| -14.77   |
| -14.62   |
| -14.48   |
| -8.86    |
| -9.1     |
| -14.33   |
| -14.4    |
| -13.89   |
| -13.60   |
| -13.75   |
| -13.46   |
| -13.31   |
| -13.17   |
| -14.19   |
| -11.33   |
| -11.64   |
| -11.49   |
| -11.80   |
| -11.95   |
| -7.2     |
| -7.18    |
| -7.34    |
| -7.51    |
| -7.67    |
| -7.99    |
| -8.15    |
| -8.31    |
| -8.48    |
| -8.64    |
| -5.71    |
| -5.87    |
| -6.4     |
| -6.87    |
| -7.4     |
| -7.21    |
| -5.26    |
| -5.43    |
| -5.60    |
| -5.77    |
| -5.94    |
| -6.11    |
| -6.45    |
| -6.28    |
| -6.62    |
| -4.34    |
| -4.52    |
| -4.69    |
| -4.87    |
| -11.2    |
| -7.37    |
| -8.80    |
| -10.87   |
| -11.18   |
| -10.71   |
| -10.40   |
| -10.25   |
| -15.64   |
| -15.79   |
| -15.49   |
| -15.35   |
| -15.93   |
| -16.8    |
| -16.22   |
| -15.20   |
| -15.6    |
| -6.43    |
| -16.37   |
| -16.51   |
| -6.79    |
| -7.71    |
| -7.54    |
| -13.2    |
| -12.88   |
| -12.73   |
| -12.59   |
| -12.44   |
| -12.30   |
| -12.15   |
| -11.72   |
| -16.66   |
| -8.96    |
| -12.11   |
| -12.26   |
| -16.95   |
| -16.81   |
| -9.12    |
| -12.42   |
| -17.10   |
| -17.24   |
| -6.96    |
| -7.87    |
| -8.4     |
| -9.45    |
| -9.29    |
| -17.39   |
| -17.54   |
| -17.83   |
| -17.97   |
| -17.68   |
| -18.12   |
| -18.27   |
| -18.41   |
| -12.57   |
| -13.4    |
| -13.19   |
| -13.35   |
| -13.50   |
| -9.61    |
| -9.77    |
| -9.93    |
| -10.10   |
| -10.26   |
| -10.42   |
| -10.58   |
| -18.56   |
| -18.71   |
| -13.66   |
| -18.85   |
| -8.21    |
| -8.54    |
| -8.87    |
| -8.71    |
| -9.4     |
| -7.13    |
| -7.30    |
| -7.64    |
| -7.81    |
| -7.98    |
| -8.33    |
| -6.61    |
| -6.78    |
| -9.21    |
| -8.50    |
| -8.67    |
| -10.91   |
| -13.81   |
| -19.14   |
| -19.0    |
| -9.69    |
| -9.55    |
| -9.84    |
| -2.54    |
| -2.69    |
| -3.93    |
| -4.7     |
| -4.51    |
| -4.65    |
| -5.22    |
| -1.70    |
| -1.53    |
| -1.37    |
| -5.62    |
| -5.31    |
| -5.15    |
| -4.85    |
| -5.0     |
| -4.8     |
| -3.92    |
| -10.99   |
| -10.85   |
| -11.14   |
| -1.46    |
| -1.64    |
| -1.82    |
| -1.35    |
| -1.54    |
| -1.67    |
| -1.49    |
| -2.23    |
| -2.42    |
| -2.79    |
| -2.61    |
| -3.73    |
| -4.14    |
| -3.91    |
| -1.23    |
| -1.41    |
| -1.78    |
| -1.60    |
| -1.11    |
| -1.30    |
+----------+
421 rows in set (0,38 sec)
