×

×

Correct!

Exercise:

Select all records from the Customers where the PostalCode column is NOT empty.

SELECT * FROM Customers WHERE PostalCode IS NOT NULL;

Not Correct

Click here to try again.

Correct!

Next ❯

SELECT * FROM Customers
WHERE w3exercise_input_no_0
 w3exercise_input_no_1
 w3exercise_input_no_2
 w3exercise_input_no_3
;

Completed 0 of 50 Exercises:

MySQL Select

Exercise 1 Exercise 2 Exercise 3 Go to MySQL Select Tutorial

MySQL Where

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

MySQL Order By

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

MySQL Insert

Exercise 1 Go to MySQL Insert Tutorial

MySQL Null

Exercise 1 Exercise 2 Go to MySQL Null Tutorial

MySQL Update

Exercise 1 Exercise 2 Exercise 3 Go to MySQL Update Tutorial

MySQL Delete

Exercise 1 Exercise 2 Go to MySQL Delete Tutorial

MySQL Functions

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

MySQL Like

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

MySQL Wildcards

Exercise 1 Exercise 2 Go to MySQL Wildcards Tutorial

MySQL In

Exercise 1 Exercise 2 Go to MySQL In Tutorial

MySQL Between

Exercise 1 Exercise 2 Exercise 3 Go to MySQL Between Tutorial

MySQL Alias

Exercise 1 Exercise 2 Go to MySQL Alias Tutorial

MySQL Join

Exercise 1 Exercise 2 Exercise 3 Go to MySQL Join Tutorial

MySQL Group By

Exercise 1 Exercise 2 Go to MySQL Group By Tutorial

MySQL Database

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