SELECT t1.teacher_name, t2.group_name FROM teachers t1, groups t2;

SELECT faculty_name FROM faculties WHERE department_funding > faculty_funding;

SELECT c.curator_lastname, g.group_name FROM curators c, groups g WHERE c.group_id = g.group_id;

SELECT t.teacher_firstname, t.teacher_lastname FROM teachers t, lectures l WHERE t.teacher_id = l.teacher_id AND l.group_name = 'P107';

SELECT t.teacher_lastname, f.faculty_name FROM teachers t, lectures l, departments d, faculties f WHERE t.teacher_id = l.teacher_id AND l.department_id = d.department_id AND d.faculty_id = f.faculty_id;

SELECT d.department_name, g.group_name FROM departments d, groups g WHERE d.department_id = g.department_id;

SELECT d.discipline_name FROM disciplines d, lectures l, teachers t WHERE d.discipline_id = l.discipline_id AND l.teacher_id = t.teacher_id AND t.teacher_lastname = 'Adams';

SELECT d.department_name FROM departments d, lectures l, disciplines di WHERE d.department_id = l.department_id AND l.discipline_id = di.discipline_id AND di.discipline_name = 'Your Discipline';

SELECT g.group_name FROM groups g, faculties f WHERE g.faculty_id = f.faculty_id AND f.faculty_name = 'Computer Science';

SELECT g.group_name, f.faculty_name FROM groups g, faculties f WHERE g.course = 5 AND g.faculty_id = f.faculty_id;

SELECT t.teacher_firstname, t.teacher_lastname, l.lecture_name, g.group_name FROM teachers t, lectures l, groups g WHERE t.teacher_id = l.teacher_id AND l.group_id = g.group_id AND l.classroom = 'B103';