Given the following relations (the primary keys are bold): MATCH ( CodM , Home Team VisitingTeam, Date,League) PLAYER ( CodP , Name, Surname, Role, Nation, Team) GOAL (C odP, CodM, MinutesIntoTheMatch...


Given the following relations (the primary keys are bold):


MATCH (CodM, Home Team VisitingTeam, Date,League)


PLAYER (CodP, Name, Surname, Role, Nation, Team)


GOAL (CodP, CodM, MinutesIntoTheMatch)


YELIOW-CARDS (CodP, CodM, MinutesIntoTheMatch)


Please note that MinutesIntoTheMatch indicates the time at which either the goal was scored or the yellow card was cautioned (e.g.. between 1st and 90th).


Write SQL Query for each player who scored 1 least one goal within the first twenty minutes into the match for at least a fifth of the matches in which he scored in 2019, show name, sumame, and nationality of the player



Jun 08, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here