An introduction about soccer Database . Sample Database: soccer. Throughout this documentation we will be working with a sample database which will help to explain some basic to advanced level database concepts. Sample Database description: The sample database represents some of the data storage and retrieval about a soccer tournament based on ...
SQL [29 exercises with solution] Sample Database: soccer. 1. From the following table, write a SQL query to count the number of venues for EURO cup 2016. Return number of venues. Go to the editor. Sample table: soccer_venue.
From the following tables, write a SQL query to count the number of goals scored by each player within normal play schedule. Group the result set on player name and country name and sorts the result-set according to the highest to the lowest scorer. Return player name, number of goals and country name. Go to the editor. Sample table: goal_details
From the following tables, write a SQL query to find those players who scored number of goals in every match. Group the result set on match number, country name and player name. Sort the result-set in ascending order by match number. Return match number, country name, player name and number of matches. Go to the editor. Sample table: goal_details
SQL soccer Database: Joins Exercise-19 with Solution. 19. From the following tables, write a SQL query to find the match where no stoppage time added in first half of play. Return match number, country name. Sample table: match_details
Return country name, player name, jersey number and position to play. Sample table: soccer_country. Sample table: match_captain. Sample table: player_mast. Sample Solution: SQL Code: SELECT country_name, player_name, jersey_no, posi_to_play FROM match_captain a JOIN soccer_country b ON a. team_id = b. country_id JOIN player_mast c ON a. player_captain = c. player_id WHERE match_no IN(48,49);
SQL Code: SELECT COUNT(*)+11 as "Number of players shared fields" FROM player_in_out WHERE match_no=( SELECT match_no FROM match_mast WHERE play_stage='F') AND in_out='I' AND team_id=( SELECT country_id FROM soccer_country WHERE country_name='France'); Sample Output:
Features. create.sql creates 6 entities connected 9 relations [stadiums, teams, players, matches, results and scores]. insert.sql adds rows to these tables - 12 stadiums and teams, 11 players to each team and results of 24 matches with details. drop.sql deletes all of data. Remaining SQL scripts form the basis further work on the database.