Write a SQL query to retrieve the names of students enrolled in the course with ID 1.

Question

Given the following 'students' and 'students_courses' tables:
```
students:
| student_id | name   |
|------------|--------|
| 1          | Alice  |
| 2          | Bob    |

students_courses:
| student_id | course_id |
|------------|-----------|
| 1          | 1         |
| 1          | 2         |
| 2          | 1         |
```
Which SQL query retrieves the names of students enrolled in the course with ID 1?

Accepted Answer

SELECT name FROM students INNER JOIN students_courses ON students.student_id = students_courses.student_id WHERE students_courses.course_id = 1;

Answer

SELECT name FROM students WHERE students.student_id IN (SELECT student_id FROM students_courses WHERE course_id = 1);

Answer

SELECT name FROM students INNER JOIN students_courses ON students.student_id = students_courses.course_id WHERE students_courses.course_id = 1;

Answer

SELECT name FROM students WHERE students.student_id = (SELECT student_id FROM students_courses WHERE course_id = 1);

Question from the SQL - Fundamentals test

Write a SQL query to retrieve the names of students enrolled in the course with ID 1.