SELECT s.id, s.Vorname, s.Username, s.Password, s.MatrikelNummer, s.Email FROM student AS s JOIN student_has_studiengang AS sm JOIN studiengang AS sg WHERE sg.universitaet_id = 1 GROUP BY s.id;