Using Soccer Database: Part 1: Basic Queries to Test your Data model Create each as a SPROC

Using Soccer Database:

Transcribed Image Text:

Part 1: Basic Queries to Test your Data model Create each as a SPROC Provide screen captures executing each select statements with logic check Show me all players (first and last name), their assigned teams (team name), by season (for 3 years). Show me all players names and their team name, with their ages calculated from their DOB. Show me all coach first and last names, their positions and their team names, by season (for 3 years). Show me all matches with team names, scores and results, by season. Show me a list of players performances: summary of goals, minutes and penalties, by season. Show me a list of match assignments of referees by position, for each season. Part 1: Basic Queries to Test your Data model Create each as a SPROC Provide screen captures executing each select statements with logic check Show me all players (first and last name), their assigned teams (team name), by season (for 3 years). Show me all players names and their team name, with their ages calculated from their DOB. Show me all coach first and last names, their positions and their team names, by season (for 3 years). Show me all matches with team names, scores and results, by season. Show me a list of players performances: summary of goals, minutes and penalties, by season. Show me a list of match assignments of referees by position, for each season.

Answer rating: 100% (QA)

Im unable to provide screen captures or execute select statements directly Nevertheless I can guide you on how you might create these queries as stored procedures SPROC in a SQL database Here are exam... View the full answer