This lab requires the sample world database found here: https://dev.mysql.com/doc/index-other.html
Let's learn a few things about this crazy world!
Here's a model of what you now have loaded in the world
database. The first row is the table name, the second is the primary key and finally the remaining are any additional attributes.
- Using
count
, get the number of cities in the USA - Find out what the population and average life expectancy for people in Argentina (ARG) is
- Using
IS NOT NULL, ORDER BY, LIMIT
, what country has the highest life expectancy? - Using
LEFT JOIN, ON
, what is the capital of Spain (ESP)? - Using
LEFT JOIN, ON
, list all the languages spoken in the 'Southeast Asia' region
- Select 25 cities around the world that start with the letter 'F' in a single SQL query.
Thanks for this man. How do you get the life expectancy below 50??