Modify your previous query to list the names and grades of all students that took Computer Science 143 and got a B- or better. Do this as a single query and do not hard-code 143's ID number in the query. (JOIN) Expected results:
+-------+-------+ | name | grade | +-------+-------+ | Lisa | A+ | | Ralph | B | +-------+-------+ 2 rows in set (0.02 sec)
SELECT DISTINCT s.name, g.grade FROM students s JOIN grades g ON g.student_id = s.id JOIN courses c ON c.id = g.course_id WHERE c.name = 'Computer Science 143' AND g.grade <= 'B-';