KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Can anyone help me with the following: Some countries have populations more than three times that of any of their neighbours (in the same region). Give the countries and regions. my try: select x.name, x.region from bbc x where x.population >all (select population*3 from bbc y where y.region = x.region) syntax is correct but no records are returned (should return 3 rows) Find each country that belongs to a region where all populations are less than 25000000. Show name, region and population. my try: select name, region, population from bbc where region not in (select distinct region from bbc where population >= 25000000) I used "not in". Is there a way to use "in" ?
Tags (comma-separated)
Save Edits
Cancel