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