Aufgabe B

1

SELECT DISTINCT MatrNr, Name, veranst_titel
FROM student NATURAL JOIN ergebnis NATURAL JOIN veranstaltung
WHERE note = 1 AND fachsemester = 1;

2

SELECT MatrNr, Name, fachsemester
FROM student NATURAL JOIN ergebnis
WHERE studiengang = 'Geschichte/Bachelor'
GROUP BY MatrNr, Name, fachsemester
HAVING SUM(note) IS NULL

3

SELECT name
FROM student
WHERE name LIKE '%meier' OR name LIKE '%maier'

UNION ALL

(SELECT name
FROM betreuer
WHERE name LIKE '%meier' OR name LIKE '%maier')

ORDER BY name

4

SELECT name, fachbereich
FROM  betreuer NATURAL JOIN veranstaltung NATURAL JOIN ergebnis
GROUP BY name, fachbereich
HAVING AVG(note) < 2.3

5

SELECT studiengang, COUNT(MatrNr)AS anzahl
FROM student NATURAL JOIN ergebnis
WHERE MatrNr = 
(SELECT DISTINCT MatrNr
FROM ergebnis
WHERE note != 5 AND note IS NOT NULL)
ORDER BY anzahl DESC
LIMIT 1