MoL Chapter 2

schema:manning;

From chapter 2

1.

Show all the data in the table world

SELECT * FROM world

SELECT * FROM world Submit SQLrestore default

result

2.

Show the continent and name

SELECT continent, name FROM world

SELECT continent, name FROM world Submit SQLrestore default

result

3.

Show the details of France

SELECT name, population, capital, continent
  FROM world
 WHERE name='France'

SELECT name, population, capital, continent FROM world WHERE name='France' Submit SQLrestore default

result

4.

Show the Countries of North America

SELECT name, continent
  FROM world
 WHERE continent='North America'

SELECT name, continent FROM world WHERE continent='North America' Submit SQLrestore default

result

5.

Which country has an area of 103000?

SELECT name, continent
  FROM world
 WHERE area=103000

SELECT name, continent FROM world WHERE area=103000 Submit SQLrestore default

result

Try It Now

6.

What country has Beijing as the capital?

SELECT name
  FROM world
 WHERE capital='Beijing'

SELECT name FROM world WHERE capital='Beijing' Submit SQLrestore default

result

7.

What is the capital of United Kingdom

SELECT capital
  FROM world
 WHERE name='United Kingdom'

SELECT capital FROM world WHERE name='United Kingdom' Submit SQLrestore default

result

8.

What countries take the name of their capital city?

SELECT name, capital
  FROM world
 WHERE name=capital

SELECT name, capital FROM world WHERE name=capital Submit SQLrestore default

result

9.

Show the countries with more than 200 million

SELECT name, population
  FROM world
 WHERE population>200000000

SELECT name, population FROM world WHERE population>200000000 Submit SQLrestore default

result

10.

Show the countries after Y in the alphabet

SELECT name, continent
  FROM world
 WHERE name>'Y'

SELECT name, continent FROM world WHERE name>'Y' Submit SQLrestore default

result