Lab 6 - Marathon

+--------+------------------+-------------+--------------+
| PGroup | Runners in Group | Best Runner | Worst Runner |
+--------+------------------+-------------+--------------+
| 01-19  |                5 |          16 |          390 |
| 20-39  |              272 |           1 |          463 |
| 40-49  |              139 |           6 |          462 |
| 50-59  |               38 |          36 |          458 |
| 60-98  |                7 |         128 |          406 |
| 99-+   |                2 |         149 |          452 |
+--------+------------------+-------------+--------------+
6 rows in set (0.00 sec)

+------------+
| Num Groups |
+------------+
|          4 |
+------------+
1 row in set (0.01 sec)

--------------+-------------------------+
| MINUTE(Pace) | Num Runners Between Min |
+--------------+-------------------------+
|            5 |                       5 |
|            6 |                      57 |
|            7 |                     147 |
|            8 |                     142 |
|            9 |                      79 |
|           10 |                      24 |
|           11 |                       7 |
|           12 |                       2 |
+--------------+-------------------------+
8 rows in set (0.01 sec)


-------+-----------------------+
| State | Num of Top 10 Runners |
+-------+-----------------------+
| RI    |                    31 |
| MA    |                    25 |
| CT    |                     5 |
| FL    |                     2 |
| NH    |                     2 |
| MO    |                     1 |
| VT    |                     1 |
+-------+-----------------------+
7 rows in set (0.00 sec)

+-------------+-----------+
| Town        | AVG Time  |
+-------------+-----------+
| LAKEVILLE   | 5837.3333 |
| NORTHFORD   | 6183.8000 |
| STONINGTON  | 6223.3333 |
| NEW MILFORD | 6303.5000 |
| ESSEX       | 6736.3333 |
| POMFRET     | 7029.6667 |
+-------------+-----------+
6 rows in set (0.00 sec)