Spring 2005

ITEC 340 Homework 2

Use the DESCRIBE and SELECT commands to examine the following tables:

Nascar.Drivers

Nascar.Races

Nascar.Results

Nascar.Teams

Nascar.Cars

Construct a separate script for each of the following. Please use the script name indicated.

H2a.sql The driver name, team name, and finish place of Brickyard 400 finishes, ordered by finish place from best finish to worst finish.

H2b.sql The driver name, and team name of all drivers who drive for a team that runs Chevrolets.

H2c.sql The driver name, race name, and finish place of all results for races that were run at the Pocono Raceway,

in order by race and within race by finish place.

H2d.sql A list of venues (Tracks) and the number or races planned at each venue.

H2e.sql The driver name, team name, race name, and venue for all first place finishes.

H2f.sql The name of any driver that raced at both the Brickyard 400 and the Coca-Cola 600.

H2g.sql The name of any driver that raced at the Brickyard 400 but not the Coca-Cola 600.

H2h.sql The name of any driver (with no names repeated) who ran a race at the Pocono Raceway.

H2i.sql The names of any drivers that have not run in any race.

H2ja.sql The name of every driver (including those that have not raced at all) and the number of races they run in,

Ordered from the driver who ran in the most races to the drivers that ran in no races.

Place your ten scripts in a folder named RU02 in your ITEC 340 submissions folder by 5:00 on Wednesday February 2nd.