Let consider the below table:

Basic Select

Show the population of specific country("Angola"):

SELECT population FROM world
  WHERE name = 'Angola';

IN and NOT IN

Checking a list The word IN allows us to check if an item is in a list.

SELECT name, population FROM world
  WHERE name IN ('Brazil', 'Russia', 'India', 'China');

BETWEEN

BETWEEN allows range checking (range specified is inclusive of boundary values).

SELECT name, area FROM world
  WHERE area BETWEEN 250000 AND 300000;