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