Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write SELECT queries to show the requested data for each of the items below: I am using sqlzoo select from world tutorial to test this
Write SELECT queries to show the requested data for each of the items below:
I am using sqlzoo select from world tutorial to test this and want to know how to do these two
- Show the population per square km (area) for countries in North America. Name the calculated field pop_per_sq_km (hint: use the alias keyword AS).
- Show the gdp per capita (that is, per person) for countries in Africa. Name the calculated field gdp_per_capita (again use AS)
Just got #2 only need #1 now
2. SELECT name, gdp/population AS gdp_per_capita FROM world WHERE continent = "Africa"
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