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 AMerican player (nation='America'), find the player's name and surname and the date on which he scored the former goal in his career.