Solution:Step 1: Use CROSS JOIN for all pairsWe want all combinations of Students and Courses, so CROSS JOIN is correct.Step 2: Filter courses starting with 'S'Use WHERE clause with LIKE 'S%' on Courses.course to select courses starting with 'S'. SELECT Students.name, Courses.course FROM Students CR

[Solved] Given tables:Students with 2 rows: John, JaneCourses with 3 rows: Math, Science, ArtWhich query returns all student-course pairs but only for courses starting with 'S'? | SQL

SQL - Advanced Joins

Given tables:
Students with 2 rows: John, Jane
Courses with 3 rows: Math, Science, Art
Which query returns all student-course pairs but only for courses starting with 'S'?

ASELECT Students.name, Courses.course FROM Students CROSS JOIN Courses WHERE Courses.course = 'S';

BSELECT Students.name, Courses.course FROM Students CROSS JOIN Courses WHERE Courses.course LIKE 'S%';

CSELECT Students.name, Courses.course FROM Students CROSS JOIN Courses WHERE Students.name LIKE 'S%';

DSELECT Students.name, Courses.course FROM Students INNER JOIN Courses;

Step-by-Step Solution

Solution:

Step 1: Use CROSS JOIN for all pairs
We want all combinations of Students and Courses, so CROSS JOIN is correct.
Step 2: Filter courses starting with 'S'
Use WHERE clause with LIKE 'S%' on Courses.course to select courses starting with 'S'. SELECT Students.name, Courses.course FROM Students CROSS JOIN Courses WHERE Courses.course LIKE 'S%'; does this correctly.
Final Answer:
SELECT Students.name, Courses.course FROM Students CROSS JOIN Courses WHERE Courses.course LIKE 'S%'; -> Option B
Quick Check:
Filter courses with LIKE 'S%' after CROSS JOIN [OK]

Quick Trick: Filter with WHERE and LIKE after CROSS JOIN [OK]

Common Mistakes:

MISTAKES

Filtering on wrong table or column
Using INNER JOIN with ON for filtering
Using equality instead of LIKE for prefix

Master "Advanced Joins" 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 tables:

Step 1: Use CROSS JOIN for all pairs

Step 2: Filter courses starting with 'S'

Final Answer:

Quick Check:

Want More Practice?