1. Create a MySQL database meeting the following requirements:
    1. Import the Tennis database (should be done from MySQL Tutorial)
  2. Execute the following queries and save the results. Also save the command you created to answer the query.
    1. SELECT PLAYERNO FROM PLAYERS WHERE JOINED > 1980 AND TOWN = 'Stratford' ORDER BY PLAYERNO;
    2. SELECT * FROM PENALTIES;
    3. Modify query 2a to display the player name instead of the player number.
    4. Display the contents of the TEAMS table.
    5. Display what tables are in the database.
  3. Submit the saved results file using the below name or paste as a text submission.
  4. Each query is worth 20% of the homework grade.

YourLastName_hw1.txt