Initializing SQL database...
Back to Questions
Join students with courses #63
mediumShow student_name with their course_name. This involves joining multiple tables or using different join types (LEFT JOIN, RIGHT JOIN). Pay attention to which join type is needed based on whether you want to include unmatched rows.
Practice with:
Database Schema
students
students information
idnameref_id
courses
courses information
idname
Expected Output
Click "Show" to see what the correct output should look like.Tip: Try solving it yourself first for better learning!
SQL Editor
Loading...
Press Ctrl+Enter to run query • Start typing for autocomplete