i have these 3 tables 

```
1. course 
------------------------ 
CourseID     CourseName             
  1            English 1
  2            English 2
  3            Math 1
  4            Math 2
2. courseRequirements
------------------------
CourseID  ReqID                
   2        1
   4        3
3. studentcoursecomplete
-----------------------
CourseID   StudentID    
   1           5

```

i need a select statement do the following 

1. show course name from table course
2. don't show the course that student complete "studentcoursecomplete"
3. don't show the course that have a requirement that student didn't finish
4. show the course that have requirement that student finish

here in this example the result will be 

```
CourseID      CourseName             
  2            English 2
  3            Math 1

```

because the student finish english 1 so he can't see it  

and he didn't finish math 1 .. so he can't see math 2 

my select statement do (1,2)  

how can i do (3,4)  

3-don't show the course that have a requirement that student didn't finish  

4- show the course that have requirement that student finish 

```
SELECT course.*
FROM course
LEFT JOIN studentcoursecomplete ON studentcoursecomplete.CourseID = course.CourseID
LEFT JOIN courseRequirements ON courseRequirements.CourseID = course.CourseID
WHERE studentcoursecomplete.CourseID IS NULL 

```