Name

COASTERS 2

Directions: Use the database file "COASTERS" to answer to questions below.

 

  1. Select the record(s) that have a track length of 3368.  What is the year built for the coaster(s) found?
  2. Select the records for Charlotte.  How many coasters did you find?

  3. Select the records of Corkscrew and Drachen Fire.  Which one has the most speed?

  4. Filter the records to show only records with a CAPACITY of 2,000.
    Which one has a track length of 3550?

  5. Select the records "King Cobra" and "Racer".  Which one is made of wood?

  6. Of the roller coaster from Ohio, which one has the shortest track length?

  7. Filter to find the roller coasters made of wood and located in NC.  How many did you find?

  8. Filter to find the roller coasters built in 1975 and made of wood. 
    Which one is the longest?

  9. How many roller coasters have a speed of less than 50 or track length greater than 3500?

  10. In which state is the coaster with the shortest track length located?