Question
Needing SQL Statements that works with the World Sample Database provided by MySql Server! ( 1 . Find out the average population and the total
Needing SQL Statements that works with the "World" Sample Database provided by MySql Server! (
1 . Find out the average population and the total number of cities for each country, and sort the result first by continent and second by average population.
2. Find out the average population and the total number of countries for each continent, and sort the result first by continent and second by average population.
3. Find out the official languages of the top 10 GNP countries, and sort the result by GNP.
4. Find out the official languages spoke by the top 10 populated counties, and sort the result by population.
5. Find out the biggest and the smallest city of each continent (country.continent, country.name).
6. Find out what country has the highest population but has the minimum surface area.
The World Schema/DB can be downloaded from https://dev.mysql.com/doc/index-other.html
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started