Alias

BETWEEN

Create Databases and Tabl

DELETE

DISTINCT

GROUP BY

HAVING

IN Operator

INNER JOIN

INSERT

LIKE

NULL value

REMOTE CONNECTION

SELECT

UPDATE

WHERE

--LIKE Operator	Description
--WHERE CustomerName LIKE 'a%'	Finds any values that start with "a"
--WHERE CustomerName LIKE '%a'	Finds any values that end with "a"
--WHERE CustomerName LIKE '%or%'	Finds any values that have "or" in any position
--WHERE CustomerName LIKE '_r%'	Finds any values that have "r" in the second position
--WHERE CustomerName LIKE 'a_%'	Finds any values that start with "a" and are at least 2 characters in length
--WHERE CustomerName LIKE 'a__%'	Finds any values that start with "a" and are at least 3 characters in length
--WHERE ContactName LIKE 'a%o'	Finds any values that start with "a" and ends with "o"

SELECT * FROM udemy.students WHERE s_country LIKE '%a%'; 

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