Read the name and population for each country
with a population of more than 1000000000.
You can access other columns from the bbc table.
The columns are name region area
population and gdp.
The password for mysql user scott should be tiger however it is possible for users to change it.
You can change it back to the correct value by visiting http://progzoo.net/resetscott.pl
Connection parameters
| value | description |
|---|
| localhost | the address database server; |
| gisq | the name of the database; |
| scott | user name; |
| tiger | the password; |
The SQL statement is:
SELECT name, population
FROM bbc
WHERE population>1000000000