Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can u please write the code u hve the table and the question can code them based in sql i just need the code how

Can u please write the code u hve the table and the question can code them based in sql i just need the code how to do them 1,2,3,4 image text in transcribed
image text in transcribed
select from iras; select from addresscity show tables TABLE Emplovers IDN Salary Deduction 1 1000.00 10 12 2000.00 22 4000.00 32 17 4000.00 10 93 IDN IRA AcctBalance 1 Al 22 A2 22 A3 100.00 400.00 12 AS 17 A IDN CompanyCity HomeCity 1Saint LouisSaint Loais 12 Saint LouisChesterficld 22 ChesterficldSaint Louis 17 Fentoe To Do Notifications Based on MySOL database world consisting of tables city, country, and countrylanguage, write each following SQL query statement: l Find the city name and population of each city with population at least 3,000,000. [2] Find the city name together with the country name for each city with city population at least 1,000,000 and the country population no more than 10,000,000. [3] Find the name and population of each country in Africa using English as their official language. 14] Find the city names in all countries using English as the official language and with city population at least 1,000,000. [5] Find the city names in all countries using English as the official language and with city population at least 1,000,000 and country population at least 10,000,000. Find the city name together with the country name of each city in all countries with city population between 50,000 and 100,000 and the life expectancy at least 70 and country population no more than 10,000,000 [6]

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_2

Step: 3

blur-text-image_3

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

Neo4j Data Modeling

Authors: Steve Hoberman ,David Fauth

1st Edition

1634621913, 978-1634621915

More Books

Students also viewed these Databases questions

Question

How did you know they were the one?

Answered: 1 week ago

Question

Do not get married, wait until I come, etc.

Answered: 1 week ago