Skip to content

Database Systems Lab

SWE · Final · Fall 25

This browser can’t show the PDF here

Open it, and your phone’s PDF viewer takes it, or download it.

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.