lab 6 Katzenjammer

------------+----------+
| FirstName  | Num Lead |
+------------+----------+
| Marianne   |       10 |
| Turid      |        7 |
| Solveig    |        6 |
| Anne-Marit |        5 |
+------------+----------+
4 rows in set (0.01 sec)

+------------+-----------------+
| FirstName  | Num Instruments |
+------------+-----------------+
| Anne-Marit |               5 |
| Marianne   |               9 |
| Solveig    |               7 |
| Turid      |               6 |
+------------+-----------------+
4 rows in set (0.00 sec)

+---------------+-----------------+
| StagePosition | COUNT(P.SongId) |
+---------------+-----------------+
| left          |               2 |
| back          |               3 |
| center        |               7 |
| right         |              20 |
+---------------+-----------------+
4 rows in set (0.00 sec)

+-----------+-----------------------------+
| FirstName | Times bass balalaika played |
+-----------+-----------------------------+
| Marianne  |                           3 |
| Solveig   |                           1 |
| Turid     |                           8 |
+-----------+-----------------------------+
3 rows in set (0.00 sec)

+----------------+
| Instrument     |
+----------------+
| accordion      |
| banjo          |
| bass balalaika |
| drums          |
| guitar         |
| keyboards      |
| mandolin       |
| trumpet        |
| ukalele        |
| xylophone      |
+----------------+
10 rows in set (0.00 sec)

+------------+-----------------------------+
| FirstName  | Times Played 1+ Instruments |
+------------+-----------------------------+
| Anne-Marit |                           1 |
| Marianne   |                           1 |
| Solveig    |                           4 |
| Turid      |                           3 |
+------------+-----------------------------+
4 rows in set (0.00 sec)