Students, Courses, and Their Instructors
Medium
joins
LinkedIn
Coursera
Google
Join students, enrollments, and courses to list each student name, course title, and the instructor teaching it.
Expected Output
| student_name | course_title | instructor |
|---|---|---|
| Alice | Databases | Dr. Smith |
| Alice | Algorithms | Dr. Jones |
| Bob | Databases | Dr. Smith |
| Carol | Calculus | Dr. Brown |
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...