Question: how to Link it to my GitHub repository.? Create a new directory under csd-310 and name it module_9. Create a new file under the module_9

Create a new directory under csd-310 and name it module_9. Create a new file under the module_9 directory and For this assignment, you will be learning how to construct and execute aggregate queries in a MySQL database.   Output player_id first_name last_name team_name Baggins Team Gandalf Baggins Team Gandalf Thorin Oakenshield how to Link it  to my GitHub repository.?

Create a new directory under csd-310 and name it module_9. Create a new file under the module_9 directory and name it pysports_join_queries.py. Add the appropriate Python code to connect to the pysports database. Using the output I have provided and the sample queries, create an INNER JOIN query to connect the player and team tables by team_id and display the res Make sure your output matches the Expected Output. Expected Output: -- DISPLAYING PLAYER RECORDS -- Player ID: 1 First Name: Thorin Last Name: Oakenshield Team Name: Team Gandalf Player ID: 2 First Name: Bilbo Last Name: Baggins Team Name: Team Gandalf Player ID: 3 First Name: Frodo Last Name: Baggins Team Name: Team Gandalf Player ID: 4 First Name: Saruman Last Name: The White Team Name: Team Sauron Player ID: 5 First Name: Angmar Last Name: Witch-king Team Name: Team Sauron Player ID: 6 First Name: Azog Last Name: The Defiler Team Name: Team Sauron Press any key to continue...

Step by Step Solution

3.49 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!