If you had the following tables:

```
   course:
   +---------------+---------------+
   |      id       |     Name      |
   |---------------|---------------| 
   |      1        |   Maths       | 
   |      2        |   English     |        
   |      3        |   Art         |        
   |      4        |   Physics     |        
   |      5        |   Psychology  |        
   +-------------------------------+        

   course_teacher:                                   
   +----------------------+---------------------+        
   |      course_id       |     teacher_id      |
   |----------------------|---------------------|
   |      1               |   1                 |
   |      2               |   1                 |
   |      1               |   2                 |
   |      2               |   2                 |
   |      3               |   2                 |
   +----------------------v---------------------+

```

How can I get a list of courses names given by teacher 1 and 2.

What I tried: `SELECT DISTINCT(`course\_id`) FROM`course\_teacher`WHERE`teacher\_id`IN (1,2);`

However that query filters all the double results it does not filter on teacher 1 AND 2.