Search results
6 de jun. de 2024 · SQL soccer Database: Basic Exercise-2 with Solution. 2. From the following table, write a SQL query to count the number of countries that participated in the 2016-EURO Cup. Sample table: player_mast.
6 de jun. de 2024 · SQL exercises on soccer Database, Practice and Solution: From the following table, write a SQL query to find the players with shot numbers they took in penalty shootout matches. Return match_no, Team, player_name, jersey_no, score_goal, kick_no.
6 de jun. de 2024 · The ORDER BY statement sorts the results by match_no in ascending order. Alternative Solution: Using JOINs and IN Clause: -- This query selects the match number, country name, player name, and jersey number for match captains who play as goalkeepers. SELECT a.match_no, -- Selecting the match number from the match_captain table aliased as 'a' b ...
6 de jun. de 2024 · Sample Solution: SQL Code: -- This query counts the number of distinct player names who serve as match captains and play as goalkeepers. SELECT count (DISTINCT player_name) -- Counting the number of distinct player names FROM match_captain a -- Specifying the match_captain table with an alias 'a' JOIN soccer_country b ON a.team_id = b.country ...
6 de jun. de 2024 · SQL exercises on soccer Database, Practice and Solution: From the following table, write a SQL query to prepare a list for the “player of the match” against each match. Return match number, play date, country name, player of the Match, jersey number.
6 de jun. de 2024 · It then applies GROUP BY and HAVING clauses to count the shots for each player and country and find the player with the maximum shots. Using Subqueries with JOINs: SELECT c.country_name, a.player_name, a.jersey_no, COUNT (b.*) AS shots FROM player_mast a JOIN penalty_shootout b ON b.player_id = a.player_id JOIN soccer_country c ON b.team_id = c ...
6 de jun. de 2024 · This SQL query selects the player name, jersey number, and country name for the player who scored the first penalty goal in the earliest game in the play stage "G". It does this by joining four tables together and using subqueries to filter the results. It happens by using a subquery to first find the match_no of the earliest game in the play ...
