Fall 2005

ITEC 340 Homework 1

Use the DESCRIBE and SELECT commands to examine the pga.players table. The table contains information on the top 100 pga golfers including some statistics for the 2005 year.

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 99,999,999.99 to keep your number output aligned.

h1a.sql	The name, age, and earnings of all players ordered from the player with the most earnings to the player with the least earnings.
h1b.sql	The name, country, age, number of top 10 finishes, and earnings for all those players that have had five or more top ten finishes.
h1c.sql	The name, country, number of events played in, number of cuts made, and the percentage of cuts made, ordered from the player with the highest cut percentage to the players with the lowest cut percentage for all players from the USA.
h1d.sql	A non-repeating list of the countries that players are from.
h1e.sql	The average earnings for all players.
h1f.sql	The name and earnings for all players from the USA and CANADA that have also earned more than one million dollars.
h1g.sql	A list of countries along with the number of players from that country and the average earnings of players from that country.
h1h.sql	A list of countries along with the number of players from that country and the average earnings of players from that country. For those countries that have five or more players.
h1i.sql	The name and earnings of the player with the highest average drive. Do not hard code your query… use a nesting.
h1j.sql	A list of countries and the number of million dollar earners from that country.

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