Solution:Step 1: Understand INNER JOIN effect on these tablesINNER JOIN returns rows where students.id matches enrollments.student_id.Step 2: Analyze query outputOnly students with enrollments appear, showing their names and courses.Final Answer:List of student names with their enrolled courses only

[Solved] Given the tables:students(id, name)enrollments(student_id, course)What will be the result of this query?SELECT students.name, enrollments.course FROM students INNER JOIN enrollments ON students.... | PostgreSQL

PostgreSQL - Joins in PostgreSQL

Given the tables:
students(id, name)
enrollments(student_id, course)
What will be the result of this query?

SELECT students.name, enrollments.course FROM students INNER JOIN enrollments ON students.id = enrollments.student_id;

AList of all students with courses, including those without enrollments

BList of student names with their enrolled courses only for matching student IDs

CList of all enrollments with student names, including unmatched enrollments

DEmpty result if any student has no enrollment

Step-by-Step Solution

Solution:

Step 1: Understand INNER JOIN effect on these tables
INNER JOIN returns rows where students.id matches enrollments.student_id.
Step 2: Analyze query output
Only students with enrollments appear, showing their names and courses.
Final Answer:
List of student names with their enrolled courses only for matching student IDs -> Option B
Quick Check:
INNER JOIN returns matching student-course pairs [OK]

Quick Trick: INNER JOIN shows only matching student-course pairs [OK]

Common Mistakes:

Expecting all students regardless of enrollment
Expecting all enrollments regardless of student
Thinking unmatched rows appear in result

Master "Joins in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Given the tables:

Step 1: Understand INNER JOIN effect on these tables

Step 2: Analyze query output

Final Answer:

Quick Check:

Want More Practice?