The hockey organiser at your school requires your assistance with the administration of the players, teams and coaches - NSC Information Technology - Question 2 - 2019 - Paper 1

To retrieve B-team coaches, use this SQL query:

SELECT Coach, TeamName FROM tblTeams WHERE TeamName LIKE "%B%";

To calculate the percentage of games won, apply this query:

SELECT TeamName, Coach, (NumberOfGamesWon / NumberOfGamesPlayed * 100) AS PercentageGamesWon
FROM tblTeams WHERE TeamName = "" + TeamName;

To find teams with an average skills level greater than 6, execute this query:

SELECT TeamName, ROUND(AVG(SkillsLevel), 1) AS AverageSkillsLevel
FROM tblPlayers
GROUP BY TeamName
HAVING AVG(SkillsLevel) > 6;

To update the number of games won for a particular team, run this SQL command:

UPDATE tblTeams
SET NumberOfGamesWon = NumberOfGamesWon + 1
WHERE TeamName <> "u/14 B";

To count the number of junior players in the u/18 A team using Delphi:

1. Assign the tbl and Rewrite.
2. Set tblPlayers to start reading first record.
3. Loop while NOT tblPlayers.EOF:
   • Check if PlayerName is in "u/18 A" and if they are junior.
4. Display the count on the label.
5. Close the file.

To display a list of coaches and goalkeepers:

1. Loop through tblTeams and tblPlayers respectively until EOF is reached.
2. Check if the TeamName matches and if a goalkeeper is present.
3. Output the relevant information in a formatted string.
4. Next record to continue the process.