Q2.7. Has any male player played in the Mens, Senior Mens, and Mixed teams for the...

Transcribed Image Text:

Q2.7. Has any male player played in the Mens, Senior Mens, and Mixed teams for the same club? List the full name of the player and the club. "Touch" rugby is a five-person game that is played in the off season (usually late Spring to late early Autumn). It is a fast and lively game where instead of tackling other players to the ground – they only have to touch or 'tag' the player for there to be a restart in play. There are 8 touch rugby clubs that compete in the Melbourne Touch Rugby Summer comptition. There are currently four competitions: mens, womens, seniors – for men over the age of 35 years, and a mixed division for teams made up of men and women. A mixed team must have a minimum of three female players in every game. A team must have a minimum of four players available to play the game. If one team is unable to field a side (minimum of four players) at the game start time they forfeit the game and suffer a walkover, and do not record any value for their score. The other team scores 28 points. The competitions have been running for several seasons, with the details of every game and participating teams and players carefully recorded. competition I season game CompetitionID INT yearly 9 SeasonID INT GamelD INT O CompetitionName VARCHAR(18) H- KO SeasonYear YEAR E- made up of O Round SMALLINT CompetitionType VARCHAR(10) CompetitionID INT • Sea sonID INT Inde xes Indexes • Team1 SMALLINT Team2 SMALLINT O Team1Score TINYINT O Team2Score TINYINT plays in a GameDate DATE O StartTime TIME O player O playerteam PlayerID INT P GamelD INT Indexes O FirstName VARCHAR... 1 TeamID SMALLINT O LastName VARCHAR... selected for 1 PlayerID INT O Sex ENUM('M', F) team 1 competes Indexes Indexes team 2 competes member of represents O club I team O clubplayer ClubID INT TeamID SMALLINT * ClubID INT O ClubName VARCHAR(35) O TeamName VARCHAR(25) belongs to hosts 1 PlayerID INT O FromDate DATE Address1 VARCHAR(25) TeamType ENUM(...) O Address2 VARCHAR(25) • ClubID INT O TODate DATE O Suburb VARCHAR(15) Indexes Indexes O Postcode CHAR(4) Inde xes Figure 1 Touch Rugby Physical E.R. Model Q2.7. Has any male player played in the Mens, Senior Mens, and Mixed teams for the same club? List the full name of the player and the club. "Touch" rugby is a five-person game that is played in the off season (usually late Spring to late early Autumn). It is a fast and lively game where instead of tackling other players to the ground – they only have to touch or 'tag' the player for there to be a restart in play. There are 8 touch rugby clubs that compete in the Melbourne Touch Rugby Summer comptition. There are currently four competitions: mens, womens, seniors – for men over the age of 35 years, and a mixed division for teams made up of men and women. A mixed team must have a minimum of three female players in every game. A team must have a minimum of four players available to play the game. If one team is unable to field a side (minimum of four players) at the game start time they forfeit the game and suffer a walkover, and do not record any value for their score. The other team scores 28 points. The competitions have been running for several seasons, with the details of every game and participating teams and players carefully recorded. competition I season game CompetitionID INT yearly 9 SeasonID INT GamelD INT O CompetitionName VARCHAR(18) H- KO SeasonYear YEAR E- made up of O Round SMALLINT CompetitionType VARCHAR(10) CompetitionID INT • Sea sonID INT Inde xes Indexes • Team1 SMALLINT Team2 SMALLINT O Team1Score TINYINT O Team2Score TINYINT plays in a GameDate DATE O StartTime TIME O player O playerteam PlayerID INT P GamelD INT Indexes O FirstName VARCHAR... 1 TeamID SMALLINT O LastName VARCHAR... selected for 1 PlayerID INT O Sex ENUM('M', F) team 1 competes Indexes Indexes team 2 competes member of represents O club I team O clubplayer ClubID INT TeamID SMALLINT * ClubID INT O ClubName VARCHAR(35) O TeamName VARCHAR(25) belongs to hosts 1 PlayerID INT O FromDate DATE Address1 VARCHAR(25) TeamType ENUM(...) O Address2 VARCHAR(25) • ClubID INT O TODate DATE O Suburb VARCHAR(15) Indexes Indexes O Postcode CHAR(4) Inde xes Figure 1 Touch Rugby Physical E.R. Model

Answer rating: 100% (QA)

Answer SELECT concatPFirstNamePLastName as FullName CClubName ... View the full answer