Table: Student
ID       NAME
1        JOHN
2        MARY
3        ROBERT
4        DENNIS

Table: Grade
ID         GRADE
1             A
1             A
1             F
2             B
3             A

SELECT name FROM student
WHERE (SELECT COUNT(*) FROM grade WHERE grade = 'F'
         AND id = student.id) = 0

SELECT `NAME`
FROM Student
WHERE 'F' NOT IN
    (SELECT GRADE FROM Grade WHERE ID = Student.ID)

SELECT name FROM Student
WHERE
NOT EXISTS (SELECT * FROM Grade WHERE Grade.id = Student.id AND grade = 'F')
OR
NOT EXISTS (SELECT * FROM Grade WHERE Grade.id = Student.id);

SELECT NAME
FROM   Student
WHERE 0 = (SELECT COUNT(*)
           FROM Student
                LEFT JOIN Grade
                USING (ID)
           WHERE GRADE='F')
GROUP BY NAME

SELECT name
FROM grade G, student S
WHERE (S.id = G.id AND 'F' NOT IN (SELECT G1.grade
                                   FROM grade G1
                                   WHERE G1.id = G.id))
      OR
      S.id NOT IN (SELECT id
                   FROM grade)
GROUP BY name