[Solved] Given tables students (id, name) and grades (student_id, grade), what is the output of this query? SELECT s.name, g.grade FROM students s INNER JOIN grades g ON s.id = g.student_id; | SQL

SQL - INNER JOIN

Given tables students (id, name) and grades (student_id, grade), what is the output of this query?

SELECT s.name, g.grade FROM students s INNER JOIN grades g ON s.id = g.student_id;

ASyntax error due to missing alias

B[{"name": "Alice", "grade": "A"}, {"name": "Bob", "grade": "B"}]

C[{"student_id": 1, "grade": "A"}]

D[{"name": "Alice"}, {"grade": "A"}]

Step-by-Step Solution

Solution:

Step 1: Understand the join condition
The query joins students and grades where students.id matches grades.student_id.
Step 2: Predict output rows
Only students with matching grades appear, showing their name and grade as pairs.
Final Answer:
[{"name": "Alice", "grade": "A"}, {"name": "Bob", "grade": "B"}] -> Option B
Quick Check:
INNER JOIN returns matched student names with grades [OK]

Quick Trick: INNER JOIN shows matched rows with selected columns [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 (id, name) and grades (student_id, grade), what is the output of this query?