入力テーブル、ville_temperatureには、テネシー州の都市ナッシュビルとノックスビルの温度測定値が含まれています。
| sn | city | State | PERIOD | temp_f |
|---|---|---|---|---|
| 1 | Nashville | Tennessee | 2010-01-01 00:00:00 | 35.1 |
| 2 | Nashville | Tennessee | 2010-01-01 01:00:00 | 36.2 |
| 3 | Nashville | Tennessee | 2010-01-01 02:00:00 | 34.5 |
| 4 | Nashville | Tennessee | 2010-01-01 03:00:00 | 33.6 |
| 5 | Nashville | Tennessee | 2010-01-01 04:00:00 | 33.1 |
| 6 | Knoxville | Tennessee | 2010-01-01 03:00:00 | 33.2 |
| 7 | Knoxville | Tennessee | 2010-01-01 04:00:00 | 32.8 |
| 8 | Knoxville | Tennessee | 2010-01-01 05:00:00 | 32.4 |
| 9 | Knoxville | Tennessee | 2010-01-01 06:00:00 | 32.2 |
| 10 | Knoxville | Tennessee | 2010-01-01 07:00:00 | 32.4 |