Solution:Step 1: Understand the dataTeacher 2 (Jones) teaches courses 100 (Math) and 200 (Science).Step 2: Analyze the queryThe query selects course names where TeacherID = 2 in TeacherCourse.Final Answer:Math and Science -> Option BQuick Check:Teacher 2 linked to both courses [OK]

[Solved] Given these tables:Teacher: (1, 'Smith'), (2, 'Jones')Course: (100, 'Math'), (200, 'Science')TeacherCourse: (1, 100), (2, 100), (2, 200)What will this query return?SELECT c.... | SQL

SQL - Table Relationships

Given these tables:

Teacher: (1, 'Smith'), (2, 'Jones')
Course: (100, 'Math'), (200, 'Science')
TeacherCourse: (1, 100), (2, 100), (2, 200)

What will this query return?

SELECT c.Name FROM Course c JOIN TeacherCourse tc ON c.ID = tc.CourseID WHERE tc.TeacherID = 2;

AOnly Math

BMath and Science

COnly Science

DNo results

Step-by-Step Solution

Solution:

Step 1: Understand the data
Teacher 2 (Jones) teaches courses 100 (Math) and 200 (Science).
Step 2: Analyze the query
The query selects course names where TeacherID = 2 in TeacherCourse.
Final Answer:
Math and Science -> Option B
Quick Check:
Teacher 2 linked to both courses [OK]

Quick Trick: Join filters courses by teacher ID [OK]

Common Mistakes:

MISTAKES

Assuming only one course per teacher
Confusing TeacherID and CourseID
Ignoring join condition

Master "Table Relationships" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Given these tables:

Step 1: Understand the data

Step 2: Analyze the query

Final Answer:

Quick Check:

Want More Practice?