CROSS JOIN in MySQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select all columns from both tables using a CROSS JOIN.

MySQL

SELECT * FROM employees [1] departments;

Drag options to blanks, or click blank then click option'

AINNER JOIN

BRIGHT JOIN

CCROSS JOIN

DLEFT JOIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using INNER JOIN instead of CROSS JOIN.

Forgetting that CROSS JOIN does not need an ON clause.

The CROSS JOIN keyword returns the Cartesian product of the two tables, combining each row of the first table with every row of the second table.

2fill in blank

medium

Complete the code to count the total number of combinations produced by a CROSS JOIN between two tables.

MySQL

SELECT COUNT(*) FROM products [1] categories;

Drag options to blanks, or click blank then click option'

AINNER JOIN

BCROSS JOIN

CLEFT JOIN

DFULL JOIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using INNER JOIN which filters rows based on a condition.

Using FULL JOIN which is not supported in MySQL.

The CROSS JOIN produces all possible combinations of rows from both tables, so counting the rows after a CROSS JOIN gives the total number of combinations.

3fill in blank

hard

Fix the error in the query to correctly perform a CROSS JOIN between two tables.

MySQL

SELECT * FROM orders [1] customers;

Drag options to blanks, or click blank then click option'

ACROSS JOIN

BINNER JOIN

CLEFT JOIN

DRIGHT JOIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using ON clause with CROSS JOIN which causes syntax error.

Confusing CROSS JOIN with INNER JOIN.

CROSS JOIN does not use an ON clause because it returns all combinations of rows. The ON clause should be removed when using CROSS JOIN.

4fill in blank

hard

Fill both blanks to create a query that selects all columns from two tables using CROSS JOIN and filters the result with a WHERE clause.

MySQL

SELECT * FROM sales [1] customers WHERE sales.region [2] 'East';

Drag options to blanks, or click blank then click option'

ACROSS JOIN

BINNER JOIN

C=

D!=

Attempts:

3 left

💡 Hint

Common Mistakes

Using INNER JOIN instead of CROSS JOIN.

Using '!=' instead of '=' in the WHERE clause.

Use CROSS JOIN to combine all rows, then filter with = in the WHERE clause to select rows where the region is 'East'.

5fill in blank

hard

Fill all three blanks to create a query that uses CROSS JOIN and filters rows where the product price is greater than 100 and the category name is 'Electronics'.

MySQL

SELECT * FROM products [1] categories WHERE products.price [2] 100 AND categories.name [3] 'Electronics';

Drag options to blanks, or click blank then click option'

ACROSS JOIN

B>

C=

DINNER JOIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using INNER JOIN instead of CROSS JOIN.

Using '<' instead of '>' for price comparison.

Using '!=' instead of '=' for category name.

The CROSS JOIN combines all rows. The WHERE clause filters products with price greater than 100 and categories named 'Electronics'.