Objective: This assignment will test your competency in executing the SELECT statements using the MySQL command line.

Directions: Using the table of data below named world, you will be constructing five separate single-line SQL statements to answer the questions:

Table name is world
name	continent	area	population	gdp
Afghanistan	Asia	652,230	25,500,100	20,343,000,000
Albania	Europe	28,748	2,831,741	12,960,000,000
Algeria	Africa	2,381,741	37,100,000	188,681,000,000
Andorra	Europe	468	78,115	3,712,000,000
Angola	Africa	1,246,700	20,609,294	100,990,000,000

[1] Create a MySQL command that will display the population of Algeria.

[2] Create a MySQL command that will display the per capita gdp (gdp/population) for each name where the area is over 5,000,000. The column name of the gdp/population should be Per Capita GDP.

[3] Create a MySQL command that will display the name and continent where the area is less than 2000 and the gdp is more than 5,000,000,000

[4] Create a MySQL command that will display the name and the population for 'Afghanistan', 'Andorra', and 'Angola'

[5] Create a MySQL command that will display each name that begins with the letter A