Operators for WHERE

Question 1

What does this symbol represent =

Answer 1

Equals
Example
SELECT city FROM world
WHERE city = ‘London’

Question 2

What does this symbol represent >

Answer 2

Greater Than
Example
SELECT population FROM world
WHERE population > 100

Question 3

What does this symbol represent

Answer 3

Less Than
Example
SELECT population FROM world
WHERE population < 100

Question 4

What does this symbol represent >=

Answer 4

Greater than or equal
Example
SELECT population FROM world
WHERE population >= 100

Question 5

What does this symbol represent <=

Answer 5

Less than or equal
Example
SELECT population FROM world
WHERE population <= 100

Question 6

What does this symbol represent <>

Answer 6

Not Equal
Example
SELECT population FROM world
WHERE population <> 100

Question 7

What does this symbol represent BETWEEN

Answer 7

Between a range
Example
SELECT population FROM world
WHERE population BETWEEN 100 and 200

Question 8

What does this symbol represent LIKE

Answer 8

Search for a pattern
Example
SELECT city FROM world
WHERE city LIKE ‘%Lon%’

Question 9

What does this symbol represent IN

Answer 9

specify multiple possible values for a column
Example
SELECT city FROM world
WHERE city IN (‘London’, ‘France’, ‘Germany’)