Вывод информации sql-запросом

SELECT s.FIO
FROM students s
JOIN jurnal j ON s.id = j.s_id
GROUP BY s.FIO
HAVING SUM(CASE WHEN j.mark = 5 THEN 1 ELSE 0 END) > 5
   AND SUM(CASE WHEN j.mark = 4 THEN 1 ELSE 0 END) > 0

Если не ошибаюсь, то как-то так

SELECT
  *
FROM
  students st
WHERE
  st.id IN (
    SELECT
      student_id
    FROM
      journal j1
    WHERE
      j1.rate = 5 AND
      EXISTS (SELECT 1 FROM journal j2 WHERE j2.student_id = j1.student_id AND j2.rate = 4)
    GROUP BY
      j1.student_id
    HAVING
      COUNT(*) > 5
  )