SQL question

For SuperBee only ... Please dont send me a hand shake

Delete scores for Week16 and Week17

Create a schedule table in your bowling database to store the attached list.  Be careful that the fields you create have the same datatype and length and the equivalent fields in the scores table.

Now the fun begins.  Create a script that uses the schedule to read the scores table and produce a list that shows: HINT - You have to use the scores table twice in your query, once to link Team 1 for any given week and once to link Team 2 for any given week.

Date, Team1 Number and Name, Total score for Game1, Game 2, Game 3 and Series and Team2 Number and Name, Total score for Game1, Game 2, Game 3 and Series . 

You also need to determine how many points each of the teams earned, they get 1 point for having the highest team score for Game 1, Game 2, Game 3, and Series.  (So each match up should produce 4 points divided among the two teams.)

Make the list in date and Team1 Number order. 

At the end list a summary of each team and how many points they earned using variables.  There will be 480 points in total for the 15 weeks we bowled.