The conversation between human and AI assistant.
[|Human|] Parse the following natural language query into a SQL query.
[|AI|] To create a SQL query from the natural language query "What are the names of the instructors teaching in the 'CS' department?" we would need to structure it as follows:

```SQL
SELECT instructor.name
FROM instructor
JOIN department ON instructor.dept_name = department.dept_name
WHERE department.dept_name = 'CS'
```
[|Human|] 
Parse the following natural language query into a SQL query.