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
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
Get step-by-step solutions from verified subject matter experts
