Name:______________________

Using the stations database at the class web site, answer these
 by using sorting, finding, and filtering.
The database contains information for 7280 weather stations around the world.  
Read the fields' descriptions to get an idea
 of what each means and what possible values it can contain.
This is a common kind of database table: many fields with cryptic codes.

What station has the hottest annual temperature:

What station has the lowest elevation/altitude:

What is the southernmost station:

What is the wettest station on Earth:

What is the elevation of La Paz, Bolivia:

What is the latitude and longitude of Stuttgart:
What is its annual average temperature:
What is its annual precipitation:


How many United States stations are there:

Find your hometown, or a closeby station, what is it:

 What is its latitude and longitude:

 What is its annual temperature and annual precipitation:

 What is its Koeppen climate classification:



How many stations in the world are at an airport:

 Of those, how many are rural:

  Of those, how many are mountainous valleys:

   Of those, how many are in Mexico:


What is the wettest station in the USA:

What is the southernmost station in the USA:

What is the northernmost station in the USA:

Of the mountainous stations in the USA, which two have
a Koeppen classification of ET (arctic tundra):

Of the USA's BWh (hot desert) stations, the most populous is:
(it's the population of the metropolitan area)

The second-most dryest station in the USA:

Which two USA states have a tropical rain forest climate (Koeppen Af):


How many Koeppen fields are 'na'?

What countries are the three stations named Georgetown in?


How many stations are above the Arctic circle (66.67 degrees north latitude)

 Which of those stations are populated?


Some of the following questions need queries to answer them.
 
How many of each of the veg values are there in the table?


What station names occur three times?
Hint: group by station name and a count 

How many of each of the topo values are there in the table?


Of the mountainous (MT) topo stations, which are lower than 1000 m in elevation:


What is the most common veg16 value and how many times does it occur:

What is the least common veg16 value and how many times does it occur:

 What is that station?