Query to count and order alphabetically


#1

howdy,

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... :\


#2

hi r937, i know you are out there smile ehehehe


#3

sorry, i don't do homework assignments smiley

do a search for mysql world database -- lots of sample queries lying around on teh interwebs


#4

ehehe, not a homework but thanks for the help smile