GATE 2025 · CS1 - Forenoon
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 tables:
player: (1,Jasprit,31) (2,Atharva,24) (3,Ishan,26) (4,Axar,30)
coach: (101,Ricky) (102,Mark) (103,Trevor)
team: (10,MI,Mumbai,102) (20,DC,Delhi,101) (30,PK,Mohali,103)
members: (1,10) (2,30) (3,10) (4,20)
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)