Answered step by step
Verified Expert Solution
Link Copied!

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

  1. 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).
  2. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2010 Barcelona Spain September 2010 Proceedings Part 1 Lnai 6321

Authors: Jose L. Balcazar ,Francesco Bonchi ,Aristides Gionis ,Michele Sebag

2010th Edition

364215879X, 978-3642158797

More Books

Students also viewed these Databases questions