12,402,241 members (39,204 online)
Rate this:
See more: (untagged)
For each continent show the continent and number of countries with populations of at least 10 million.

world(name, continent, area, population, gdp)

```select continent, count(name) from world
group by continent
having Min(population)>=10000000
```
what is the Correct Anwer?!

Edit: moved over to the GimmeCodezz/Homework section. - Marco Bertschi
Posted 5-May-13 8:06am
mahmii273
Updated 5-May-13 10:26am
v2
Maciej Los 5-May-13 14:24pm

Please, be more specific and provide more details (example data). Use "Improve question" widget.

Query look correct!
ThePhantomUpvoter 5-May-13 14:28pm

What is the problem?
ridoy 5-May-13 15:55pm

I think that is good enough.

Rate this:

## Solution 1

Your query is just about correct as it stands... just one thing isn't quite right.

The "having" clause is only required when you are wanting to perform some operation over set functions, eg: sum(X), min(Y), count(Z) etc... this is not required in this case. A simple where clause will suffice - try doing that and get back to us if you still can't get it working.

Top Experts
Last 24hrsThis month
 OriginalGriff 250 Richard Deeming 223 Karthik Bangalore 180 ppolymorphe 145 F-ES Sitecore 135
 OriginalGriff 7,073 ppolymorphe 3,030 Karthik Bangalore 2,917 F-ES Sitecore 2,187 Richard MacCutchan 2,125