[Solved] Given tables Students (StudentID primary key) and Enrollments (StudentID foreign key), what will this query return?SELECT Students.Name, Enrollments.Course FROM Students JOIN Enrollments ON Students.... | SQL

SQL - INNER JOIN

Given tables Students (StudentID primary key) and Enrollments (StudentID foreign key), what will this query return?

SELECT Students.Name, Enrollments.Course FROM Students JOIN Enrollments ON Students.StudentID = Enrollments.StudentID;

AList of all students without courses

BEmpty result set

CList of all courses without student names

DList of student names with their enrolled courses

Step-by-Step Solution

Solution:

Step 1: Understand join condition
The join matches Students.StudentID with Enrollments.StudentID, linking students to their courses.
Step 2: Analyze SELECT columns
It selects student names and their courses from matching rows.
Final Answer:
List of student names with their enrolled courses -> Option D
Quick Check:
Join on keys returns matching student-course pairs [OK]

Quick Trick: Join returns matching rows with related data [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given tables Students (StudentID primary key) and Enrollments (StudentID foreign key), what will this query return?