Question from the SQL - Fundamentals test

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

Easy

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?

Author: Vincent CotroStatus: PublishedQuestion passed 1356 times

Edit

Community Evaluations

Sylvie

03/04/2024

Quelle est la bonne solution car j'ai hésité entre trois réponses : 1,2,4. Il semblerait qu'en cochant la1 et la 4 la réponse est partielle ...