Richtige "Antworten" der Abfragen 1 bis 10
                 ==============================================

1.) 
+-------+----------+---------+------------+------------------------+-------+--------+
| id    | nachname | vorname | geschlecht | strasse                | plz   | ort    |
+-------+----------+---------+------------+------------------------+-------+--------+
| BC234 | Huber    | Claudia | w          | Blaubeurer Strasse 127 | 89079 | Ulm    |
| CD555 | Huber    | Steffi  | w          | Kelternweg 2a          | 89079 | Ulm    |
| UQ888 | Erhtle   | Claudia | w          | Talweg 13a             | 89250 | Senden |
+-------+----------+---------+------------+------------------------+-------+--------+
3 rows in set (0.00 sec)

2.)
+---------+----------------+
| name    | typbezeichnung |
+---------+----------------+
| Audi    | A3             |
| Audi    | A4             |
| Audi    | A5             |
| Audi    | A6             |
| Audi    | A8             |
| Audi    | TT             |
| BMW     | 1er            |
| BMW     | 3er            |
| BMW     | 5er            |
| BMW     | 6er            |
| BMW     | 7er            |
| BMW     | M3             |
| Ford    | Fiesta         |
| Ford    | Focus          |
| Ford    | Mondeo         |
| Opel    | Astra          |
| Opel    | Corsa          |
| Opel    | Sigma          |
| Porsche | 911            |
| Porsche | Cayenne        |
| Porsche | Cayman         |
| VW      | Golf           |
| VW      | Lupo           |
| VW      | Passat         |
| VW      | Sharan         |
| VW      | Touareg        |
| VW      | Touran         |
+---------+----------------+
27 rows in set (0.01 sec)

3.)
+----------+
| az       |
+----------+
| ABC-4711 |
| QT-578   |
+----------+
2 rows in set (0.00 sec)

4.)
+----------+---------+--------------------+-------+------------+
| nachname | vorname | strasse            | plz   | ort        |
+----------+---------+--------------------+-------+------------+
| Mueller  | Kurt    | Heilmeyersteige 12 | 89079 | Ulm        |
| Wagner   | Bernd   | Hauptsrasse 11     | 89111 | Neu-Ulm    |
| Kaiser   | Georg   | Prinzenstrasse 19  | 78911 | Heidenheim |
| Kaiser   | Georg   | Prinzenstrasse 19  | 78911 | Heidenheim |
| Erhtle   | Claudia | Talweg 13a         | 89250 | Senden     |
+----------+---------+--------------------+-------+------------+
5 rows in set (0.00 sec)

5.)
+--------------------------------------------+
| bezeichnung                                |
+--------------------------------------------+
| Ueberholverstoss                           |
| Rotlichtverstoss qualifiziert              |
| Geschwindigkeitsueberschreitung ausserorts |
| Fahren ohne Gurt                           |
+--------------------------------------------+
4 rows in set (0.00 sec)

6.)
+-------------+
| kennzeichen |
+-------------+
| UL-CD100    |
| UL-CE95     |
| UL-SH999    |
+-------------+
3 rows in set (0.00 sec)

7.)
+--------------------+
| count(kennzeichen) |
+--------------------+
|                  2 |
+--------------------+
1 row in set (0.02 sec)

8.)
+-------------+
| sum(punkte) |
+-------------+
| 10          |
+-------------+
1 row in set (0.00 sec)

9.)
+------+----------------+
| name | typbezeichnung |
+------+----------------+
| Seat | Marbella       |
+------+----------------+
1 row in set (0.00 sec)

10.)
+----------+----------------+
| name     | typbezeichnung |
+----------+----------------+
| Chrysler | Crossfire      |
+----------+----------------+
1 row in set (0.01 sec)