Exercise v3.0

Correct!

Insert the missing parts in the JOIN clause to join the two tables Orders and Customers, using the CustomerID field in both tables as the relationship between the two tables.

SELECT * FROM Orders LEFT JOIN Customers @(20)=
@(20);

SELECT * FROM Orders LEFT JOIN Customers ON Orders.CustomerID=
Customers.CustomerID;

Not Correct

Click here to try again.

Correct!

Go to w3schools.com

Reset Score

Close This Menu

SQL Select

Exercise 1 Exercise 2 Exercise 3 Go to SQL Select Tutorial

SQL Where

Exercise 1 Exercise 2 Exercise 3 Exercise 4 Exercise 5 Go to SQL Where Tutorial

SQL Order By

Exercise 1 Exercise 2 Exercise 3 Go to SQL Order By Tutorial

SQL Insert

Exercise 1 Go to SQL Insert Tutorial

SQL Null

Exercise 1 Exercise 2 Go to SQL Null Tutorial

SQL Update

Exercise 1 Exercise 2 Exercise 3 Go to SQL Update Tutorial

SQL Delete

Exercise 1 Exercise 2 Go to SQL Delete Tutorial

SQL Functions

Exercise 1 Exercise 2 Exercise 3 Exercise 4 Exercise 5 Go to SQL Functions Tutorial

SQL Like

Exercise 1 Exercise 2 Exercise 3 Exercise 4 Exercise 5 Go to SQL Like Tutorial

SQL Wildcards

Exercise 1 Exercise 2 Exercise 3 Exercise 4 Go to SQL Wildcards Tutorial

SQL In

Exercise 1 Exercise 2 Go to SQL In Tutorial

SQL Between

Exercise 1 Exercise 2 Exercise 3 Go to SQL Between Tutorial

SQL Alias

Exercise 1 Exercise 2 Go to SQL Alias Tutorial

SQL Join

Exercise 1 Exercise 2 Exercise 3 Go to SQL Join Tutorial

SQL Group By

Exercise 1 Exercise 2 Go to SQL Group By Tutorial

SQL Database

Exercise 1 Exercise 2 Exercise 3 Exercise 4 Exercise 5 Exercise 6 Exercise 7 Go to SQL Database Tutorial

Reset the Score?

This will reset the score of ALL 52 exercises.

Are you sure you want to continue?

Congratulations!

You have finished all 52 SQL exercises.

Share your score: