Question: If you have this table exist in sql how can do question 4,5,6 i mean the code can you please write the code i need

If you have this table exist in sql how can do question 4,5,6 i mean the code can you please write the code i need to make sure thank you in advance  If you have this table exist in sql how can do
question 4,5,6 i mean the code can you please write the code

select from iras select from addresscity show tables TABLE Employees: LName Peter Mary Tony Mike John IDN Salary Deduction 1 1000.00 10 12 2000.00 22 4000.00 32 17 4000.00 0 93 0 TABLE IRAs: IDN IRA Acct Balance 1 A 100.00 22 A2 22 A 93 A4 12 AS 17 A6 200.00 400.00 500.00 0.00 0.00 TABLE AddressCity: IDN CompanyCity HomeCity 1 Saint Louis Saint Louis 12 Saint LouisChesterfield 22 ChesterfieldSaint Louis 93 17 Fenton Fenton Calendar ToDo Notifications Inbo Based on MySQL database world consisting of tables city, count following SQL query statement: ry, and countrylanguage, write each of the ] Find the city name and population of each city with population at least 3,000,000. 12] 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. [13] Find the name and population of each country in Africa using English as their official language. [4] Find the city names in all countries using English as the official language and with city population at least 1,000,000. 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. I5] 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] select from iras select from addresscity show tables TABLE Employees: LName Peter Mary Tony Mike John IDN Salary Deduction 1 1000.00 10 12 2000.00 22 4000.00 32 17 4000.00 0 93 0 TABLE IRAs: IDN IRA Acct Balance 1 A 100.00 22 A2 22 A 93 A4 12 AS 17 A6 200.00 400.00 500.00 0.00 0.00 TABLE AddressCity: IDN CompanyCity HomeCity 1 Saint Louis Saint Louis 12 Saint LouisChesterfield 22 ChesterfieldSaint Louis 93 17 Fenton Fenton Calendar ToDo Notifications Inbo Based on MySQL database world consisting of tables city, count following SQL query statement: ry, and countrylanguage, write each of the ] Find the city name and population of each city with population at least 3,000,000. 12] 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. [13] Find the name and population of each country in Africa using English as their official language. [4] Find the city names in all countries using English as the official language and with city population at least 1,000,000. 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. I5] 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!