python - guessing game

For this assignment, you will be creating a guessing game. Things you need to accomplish:

• Create tables in SQL Server to store game sessions and the guesses associated with them. You'll be expected to be able to query how many games were played and the average number of guesses it took to get the correct answer.
• Generate a random number between 1 and 100.
• Take input from the user and tell them if they got the number correct, they are too low, or too high.
• Create stored procedures to log your games and guesses

As mentioned in class, for this first assignment I'm not looking for bullet-proof code. Don't worry about bad data entry of any sort - assume I'll stay in bounds as I grade these.

Turn in your .py file for the game, along with a .sql file that creates your tables and stored procedures.