Results 1 to 4 of 4
Feb 23, 2010, 04:11 #1
query to count and order alphabetically
need a help with an exercise, i've been trying but with no success so far.
1 BD with 2 tables: continents, and countries
continents has id_cont, name_cont, pop_cont, area_cont, dens_cont;
countries has id_country, name_contry, pop_coutry, area_country, desn_pop_country, and id_cont;
need a few queries:
1 - list of countries and respective continents, ordered alphabetically by continent and afterwards by country;
2 - average population of europe (pop_count)
3 - count how many countries has each continente, ordered from the biggest to smallest
any help would be much appreciated. i know the theory but can't put it to practice... :\oi!
Feb 23, 2010, 04:19 #2
hi r937, i know you are out there eheheheoi!
Feb 23, 2010, 04:25 #3
- Join Date
- Jul 2002
- Toronto, Canada
- 53 Post(s)
- 2 Thread(s)
Feb 23, 2010, 04:28 #4
ehehe, not a homework but thanks for the helpoi!