Ausgaben der SQL-Abfragen von Aufgabe 1
       =======================================

1.)
+------------+----------+----------+---------------+
| datum      | zeit     | filialID | mitarbeiterID |
+------------+----------+----------+---------------+
| 2005-01-01 | 18:30:00 | lehr     |             7 |
| 2005-01-08 | 18:30:00 | lehr     |             7 |
| 2005-01-29 | 18:30:00 | wibl     |             7 |
+------------+----------+----------+---------------+
3 rows in set (0.00 sec)

2.)
+-----------------+
| max(entfernung) |
+-----------------+
|              26 |
+-----------------+
1 row in set (0.00 sec)

3.)
+-------+
| plz   |
+-------+
| 89400 |
+-------+
1 row in set (0.00 sec)

4.)
+------------+----------+----------+---------------+
| datum      | zeit     | filialID | mitarbeiterID |
+------------+----------+----------+---------------+
| 2007-06-10 | 10:15:00 | dorn     |            20 |
+------------+----------+----------+---------------+
1 row in set (0.00 sec)

5.)
+------+----------------------+-----------+-------+
| id   | strasse              | ort       | plz   |
+------+----------------------+-----------+-------+
| dorn | St. Ulrich-Strasse 3 | Dornstadt | 89160 |
| hbf  | Bahnhofstrasse 1     | Ulm       | 89100 |
| bbs  | Blaubeurer Strasse 3 | Ulm       | 89200 |
| send | Schwabenweg 16       | Senden    | 89170 |
+------+----------------------+-----------+-------+
4 rows in set (0.01 sec)

6.)
+----------------------+------------+
| strasse              | entfernung |
+----------------------+------------+
| Bahnhofstrasse 1     |          9 |
| Talweg 12            |         14 |
| Blaubeurer Strasse 3 |         12 |
| Tannenhof 1          |          4 |
+----------------------+------------+
4 rows in set (0.00 sec)

7.)
+---------------+------------+----------+
| name          | datum      | zeit     |
+---------------+------------+----------+
| Anna Bolika   | 2006-01-21 | 18:30:00 |
| Ingrid Enzien | 2006-06-17 | 18:30:00 |
+---------------+------------+----------+
2 rows in set (0.00 sec)

8.)
+----------+-------------+
| filialID | sum(betrag) |
+----------+-------------+
| bbs      | 28000       |
| dorn     | 38600       |
| hbf      | 12800       |
| lehr     | 45000       |
| send     | 31300       |
| wibl     | 16900       |
+----------+-------------+
6 rows in set (0.00 sec)

9.)
+------+----------------------+-------+-----------+-------------+
| id   | strasse              | plz   | ort       | sum(betrag) |
+------+----------------------+-------+-----------+-------------+
| dorn | St. Ulrich-Strasse 3 | 89160 | Dornstadt | 38300       |
| lehr | Talweg 12            | 89070 | Ulm-Lehr  | 40300       |
| send | Schwabenweg 16       | 89170 | Senden    | 45200       |
+------+----------------------+-------+-----------+-------------+
3 rows in set (0.00 sec)

10.)
+----------------+----+
| name           | id |
+----------------+----+
| Rainer Zufall  |  4 |
| Ingrid Enzien  |  6 |
| Karl Eidoskop  |  8 |
| Nick Erchen    | 11 |
| Kurt Zundklein | 12 |
+----------------+----+
5 rows in set (0.00 sec)