Solution:Step 1: Understand the requirementWe want all combinations of fruits and sizes except those where fruit is 'Banana'.Step 2: Analyze the queriesSELECT Fruits.name, Sizes.size FROM Fruits CROSS JOIN Sizes WHERE Fruits.name 'Banana'; uses CROSS JOIN and filters out 'Banana' correctly. SELECT

[Solved] You have two tables:Fruits with rows: Apple, Banana, CherrySizes with rows: Small, LargeWhich SQL query lists all fruit-size pairs but excludes pairs where the fruit is 'Banana'? | SQL

SQL - Advanced Joins

You have two tables:
Fruits with rows: Apple, Banana, Cherry
Sizes with rows: Small, Large
Which SQL query lists all fruit-size pairs but excludes pairs where the fruit is 'Banana'?

ASELECT Fruits.name, Sizes.size FROM Fruits CROSS JOIN Sizes WHERE Fruits.name = 'Banana';

BSELECT Fruits.name, Sizes.size FROM Fruits INNER JOIN Sizes ON Fruits.name <> 'Banana';

CSELECT Fruits.name, Sizes.size FROM Fruits CROSS JOIN Sizes WHERE Sizes.size <> 'Banana';

DSELECT Fruits.name, Sizes.size FROM Fruits CROSS JOIN Sizes WHERE Fruits.name <> 'Banana';

Step-by-Step Solution

Solution:

Step 1: Understand the requirement
We want all combinations of fruits and sizes except those where fruit is 'Banana'.
Step 2: Analyze the queries
SELECT Fruits.name, Sizes.size FROM Fruits CROSS JOIN Sizes WHERE Fruits.name <> 'Banana'; uses CROSS JOIN and filters out 'Banana' correctly. SELECT Fruits.name, Sizes.size FROM Fruits INNER JOIN Sizes ON Fruits.name <> 'Banana'; uses INNER JOIN incorrectly with a condition that is not a join condition. SELECT Fruits.name, Sizes.size FROM Fruits CROSS JOIN Sizes WHERE Sizes.size <> 'Banana'; filters on Sizes.size incorrectly. SELECT Fruits.name, Sizes.size FROM Fruits CROSS JOIN Sizes WHERE Fruits.name = 'Banana'; includes only 'Banana' instead of excluding it.
Final Answer:
SELECT Fruits.name, Sizes.size FROM Fruits CROSS JOIN Sizes WHERE Fruits.name <> 'Banana'; -> Option D
Quick Check:
Filter after CROSS JOIN excludes unwanted rows [OK]

Quick Trick: Filter unwanted rows after CROSS JOIN [OK]

Common Mistakes:

MISTAKES

Using INNER JOIN with non-join condition
Filtering on wrong table or column
Including instead of excluding 'Banana'

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

You have two tables:

Step 1: Understand the requirement

Step 2: Analyze the queries

Final Answer:

Quick Check:

Want More Practice?