Spring 2006

ITEC 340 Homework 1

Use the DESCRIBE and SELECT commands to examine the gymnastics.results table. Construct a separate script for each of the following. Please use the script name indicated. Please note that the second character in each script name is the number one not the letter L. If you wish, you may use the command set numformat 999.99 to keep your numeric output aligned.

h1a.sql	The athlete first name, athlete last name, meet, event, and score for all results ordered from the highest score to the lowest score.
h1b.sql	The results for just the Snowflake meet ordered by Event and within Event by score.
h1c.sql	A non-repeated list of athletes to include their first and last name.
h1d.sql	The athlete first name, athlete last name, meet, event, and score for all Floor or Vault scores that are a 9.0 or higher.
h1e.sql	The average score for all results.
h1f.sql	The average score for each event.
h1g.sql	The average score for each event in each meet.
h1h.sql	The all-around scores of all athletes that participated in the snowflake meet. (To get the all around score you must add the four individual scores.)
h1i.sql	The athlete first name, athlete last name, meet, event, and score for the single highest individual event score.
h1j.sql	The first name, last name, and all-around score of any athlete that scored a 33 or over in the Valentine meet.

Place your ten scripts in a folder named RU01 in your ITEC 340 submissions folder by 5:00 on Wednesday, January 25th.