CREATE A DATABASE CALLED country THAT HAS ONE TABLE WITH THE FOLLOWING FIELDS:

name of country (primary key)

population

primary language

USE THE WEB TO OBTAIN INFORMATION and POPULATE THE TABLE WITH AT LEAST 8 LINES OF DATA.

RUN THE FOLLOWING QUERIES ON YOUR DATABASE:

1. List the entire table

2. List of all countries with populations sorted by population in descending order

3. List country with the smallest population (Read up on the LIMIT keyword in MySQL )

4. List all countries that have a primary language of FRENCH