Database Systems Lab
SWE · Final · Fall 25
Read the questions as text
Read off the PDF by AI, so it may have mistakes. The PDF is the original.
Lab Final – Fall 2025
Player
player_id | player_name | age | country | role | coach_id | ranking
1 | Rohit Sharma | 36 | India | Batsman | 101 | 2
2 | Joe Root | 33 | England | Batsman | 102 | 4
3 | Shaheen Afridi | 24 | Pakistan | Bowler | 103 | 5
4 | Shakib Al Hasan | 36 | Bangladesh | All-rounder | 104 | 3
5 | Steve Smith | 34 | Australia | Batsman | 101 | 6
6 | Rashid Khan | 25 | Afghanistan | Bowler | 104 | 1
Coach
coach_id | coach_name | country | experience_years | specialty | salary
101 | Rahul Dravid | India | 12 | Batting | 30000
102 | Brendon McCullum | New Zealand | 10 | Batting | 28000
103 | Waqar Younis | Pakistan | 14 | Fast Bowling | 32000
104 | Notashjid Islam | Bangladesh | 11 | Spin Bowling | 25000
105 | Justin Langer | Australia | 15 | Motivation | 35000
106 | Tom Moody | Australia | 13 | All-rounder | 33000
Create a database with your name. The SQL query to construct the tables are available in the following link –
https://shorturl.at/BBF5q
Now, execute the following queries in SQL-
1. List all player names along with the names of their coaches.
2. Find how many players are trained by each coach.
3. Display the coaches whose salary is above the average salary of all coaches.
4. Write an SQL query to find the coach name of the player ‘Rashid Khan’.
5. Write an SQL query to find the country that has the highest number of coaches.
6. Write an SQL query to list all coaches who do not train any player.
7. Write an SQL query to display the names of the players whose country matches the country of their coach.