Consider the following database tables of a sports league. \( \begin{array}{l…

GATE · 2025 · CS · Set 1 · Computer Science & IT

Consider the following database tables of a sports league.

player(pid,pname,age)team(tid,tname,city,cid)coach(cid,cname)members(pid,tid) \begin{array}{l l} \textbf{player}(\text{pid}, \text{pname}, \text{age}) & \textbf{team}(\text{tid}, \text{tname}, \text{city}, \text{cid}) \\ \textbf{coach}(\text{cid}, \text{cname}) & \textbf{members}(\text{pid}, \text{tid}) \end{array}

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

SELECT MIN(P.age)FROM player PWHERE P.pid IN (SELECT M.pidFROM team T,coach C,members MWHERE C.cname=′Mark′AND T.cid=C.cidAND M.tid=T.tid )\begin{aligned} &\text{SELECT } \text{MIN}(P.\text{age}) \\ &\text{FROM } \textbf{player} \ P \\ &\text{WHERE } P.\text{pid} \text{ IN } ( \\ &\quad \text{SELECT } M.\text{pid} \\ &\quad \text{FROM } \textbf{team} \ T, \textbf{coach} \ C, \textbf{members} \ M \\ &\quad \text{WHERE } C.\text{cname} = 'Mark' \\ &\quad \text{AND } T.\text{cid} = C.\text{cid} \\ &\quad \text{AND } M.\text{tid} = T.\text{tid} \ ) \end{aligned}

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

Attempted by 155 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…