Many queries using criteria from a different table

[Never Hide]

Hi guys,
I have a DB that I store the ranking of several sites around the world using data I've gathered from Alexa (http://www.alexa.com)
I have 3 tables in my DB
Country(ID, Name)
Rank(Country_ID,Site_ID,Rank,Rank_Timestamp)
Site(ID,Name)

I want to export data about the rank to create some graphs in excel.
What I'd like to do is to write some code so that I can go through the list of countries and for each country make a selection query to show the ranks of all sites fo that country. I could do it manually but it's like 150 countries.
Thanks in advance guys

 

[rodmc]

create a query invoking the GROUP BY CountryID???????