Reference no: EM131680342

Professor. Dunn
10/4/17
Queries:
1. Select all players whose player number is 10 :
SELECT tblPlayers.PlayerName, tblPlayers.PlayerPositionID, tblPlayers.TeamID, tblPlayers.ContryID
FROM tblPlayers
WHERE (((tblPlayers.PlayerPositionID)=2002));

2. All players who play striking position:

SELECT tblPlayers.PlayerName, tblPlayers.PlayerPositionID, tblPlayers.TeamID, tblPlayers.ContryID
FROM tblPlayers
WHERE (((tblPlayers.PlayerPositionID)=2002));

3. All players who play defending position:
SELECT tblPlayers.PlayerName, tblPlayers.PlayerPositionID, tblPlayers.Weight
FROM tblPlayers
WHERE (((tblPlayers.PlayerPositionID)=1001));

4. Select players who have previously played for Manchester:

SELECT tblPlayers.PlayerName, tblPlayerHistory.PreviousTeams, tblPosition.PlayerPosition
FROM tblPosition INNER JOIN (tblPlayers INNER JOIN tblPlayerHistory ON tblPlayers.PlayerID = tblPlayerHistory.PlayerID) ON tblPosition.PlayerPositionID = tblPlayers.PlayerPositionID
WHERE (((tblPlayerHistory.PreviousTeams)="ManchesterUnited"));

5. Select all players who weigh below 80 kg:
SELECT tblPlayers.PlayerName, tblPosition.PlayerPosition, tblPlayerMarketValue.MarketValueAssessedID, tblPlayers.Weight
FROM (tblPosition INNER JOIN tblPlayers ON tblPosition.PlayerPositionID = tblPlayers.PlayerPositionID) INNER JOIN tblPlayerMarketValue ON tblPlayers.PlayerID = tblPlayerMarketValue.PlayerID
WHERE (((tblPlayers.Weight)<80));
6. Select all matches that took place before 9/30/2017:

SELECT tblMatches.MatchDate, tblTeams.TeamName, tblTeams_1.TeamName
FROM tblTeams_1 INNER JOIN (tblTeams INNER JOIN tblMatches ON tblTeams.TeamID = tblMatches.HomeTeamID) ON tblTeams_1.TeamID = tblMatches.VisitingTeamID
WHERE (((tblMatches.MatchDate)<#9/30/2017#));

7. Select all players from brazil:

SELECT tblPlayers.PlayerName, tblPlayers.DateOfBirth, tblCountry.CountryName, tblTeams.TeamName
FROM (tblCountry INNER JOIN tblPlayers ON tblCountry.CountryID = tblPlayers.ContryID) INNER JOIN tblTeams ON tblPlayers.TeamID = tblTeams.TeamID
WHERE (((tblCountry.CountryName)="Brazil"));

8. Players whose market value is greater than $700000:

SELECT tblPlayers.PlayerName, tblPlayers.DateOfBirth, tblMarketValue.MarketValue, tblTeams.TeamName, tblCountry.CountryName
FROM tblCountry INNER JOIN ((tblPlayers INNER JOIN (tblMarketValue INNER JOIN tblPlayerMarketValue ON tblMarketValue.MarketValueID = tblPlayerMarketValue.MarketValueID) ON tblPlayers.PlayerID = tblPlayerMarketValue.PlayerID) INNER JOIN tblTeams ON tblPlayers.TeamID = tblTeams.TeamID) ON tblCountry.CountryID = tblPlayers.ContryID
WHERE (((tblMarketValue.MarketValue)>700000));

9. Select all players from spain:

SELECT tblPlayers.PlayerName, tblPosition.PlayerPosition, tblPlayers.Weight, tblCountry.CountryName
FROM tblCountry INNER JOIN ((tblTeams INNER JOIN tblMatches ON tblTeams.TeamID = tblMatches.HomeTeamID) INNER JOIN (tblPosition INNER JOIN tblPlayers ON tblPosition.PlayerPositionID = tblPlayers.PlayerPositionID) ON tblTeams.TeamID = tblPlayers.TeamID) ON tblCountry.CountryID = tblPlayers.ContryID
WHERE (((tblPlayers.ContryID)=8));

10. Select all players whose player number is 3:
SELECT tblPlayers.PlayerName, tblPlayers.PlayerNumber, tblPlayers.PlayerID
FROM tblPlayers
WHERE (((tblPlayers.PlayerNumber)=3));

Attachment:- datdabse.rar