Alias

BETWEEN

Create Databases and Tabl

DELETE

DISTINCT

GROUP BY

HAVING

IN Operator

INNER JOIN

INSERT

LIKE

NULL value

REMOTE CONNECTION

SELECT

UPDATE

WHERE

SELECT * FROM udemy.students WHERE s_country is null;

-- # ID, s_name, s_country, s_grade
-- 6, Larry, <sup>null</sup>, 65

SELECT * FROM udemy.students WHERE s_country is NOT null;

-- # ID, s_name, s_country, s_grade
-- 1, Richard, Canada, 90
-- 2, Steve, Canada, 80
-- 3, Melisa, USA, 60
-- 4, Bill, London, 75