Skip to content

Files

Latest commit

a2c7b24 · Sep 16, 2020

History

History

SELECT_basics

0. SELECT Basics

1.Show the population of Germany.

SELECT population FROM world
WHERE name = 'Germany';

2.Show the name and the population for 'Sweden', 'Norway' and 'Denmark'.

SELECT name, population FROM world
WHERE name IN ('Sweden', 'Norway', 'Denmark');

3.Show the country and the area for countries with an area between 200,000 and 250,000.

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