Skip to content
GATEiit

GATE CSE 2025 Session 1 Q55: Minimum age of players coached by Mark

Question

Consider the following database tables of a sports league.

player(pid, pname, age) coach(cid, cname) team(tid, tname, city, cid) members(pid, tid)

An instance of the table and an SQL query are given.

player
pidpnameage
1Jasprit31
2Atharva24
3Ishan26
4Axar30
coach
cidcname
101Ricky
102Mark
103Trevor
team
tidtnamecitycid
10MIMumbai102
20DCDelhi101
30PKMohali103
members
pidtid
110
230
310
420
SELECT MIN(P.age)
FROM player P
WHERE P.pid IN (
    SELECT M.pid
    FROM team T, coach C, members M
    WHERE C.cname = 'Mark'
          AND T.cid = C.cid
          AND M.tid = T.tid
    )

The value returned by the given SQL query is ______. (Answer in integer)

Try it: numerical answer: type the value

Numerical answer. No negative marking.
Show answer and explanation

Answer: 26 (official GATE 2025 final answer key)

Concept used: Evaluating a nested IN subquery that joins three tables, then an aggregate.

First step: Mark has cid 102, which coaches team tid 10 (MI); find the members of team 10 and their ages.

Full step-by-step solution

Detailed working, common mistakes and linked mock tests will be available with a free GATEiit account. Log-in is coming soon.

Share this question

WhatsAppDownload image

Source: official GATE 2025 Session 1 CS question paper and final answer key, organised by IIT Roorkee. Question paper · Answer key

More Databases PYQs

PracticePractise Databases questions →Full paperAll GATE CSE 2025 Session 1 questions →