SELECT students.name
FROM students
INNER JOIN (
SELECT student_id from  student_grades
GROUP BY student_id
HAVING min(student_grade) > 60)
AS goodstudents
ON goodstudents.student_id = students.id;


SELECT students.name
FROM students
WHERE students.id not in (
  SELECT student_id
  FROM student_grades
  LEFT JOIN lectures
  ON lectures.id = student_grades.lecture_id
  WHERE student_grade <  passing_grade
);


SELECT students.name
FROM students
WHERE students.id not in (
  SELECT student_id
  FROM student_grades
    LEFT JOIN lectures
      ON lectures.id = student_grades.lecture_id
  WHERE student_grade <  passing_grade
) AND (students.school_id = 2 or students.school_id = 6 or students.school_id = 1);


SELECT students.name
FROM students
  INNER JOIN (
               SELECT student_id from  student_grades
               GROUP BY student_id
               HAVING min(student_grade) > 60)
    AS goodstudents
    ON goodstudents.student_id = students.id
       WHERE students.school_id = 2 or students.school_id = 6 or students.school_id = 1;