Q45

Consider the following database tables of a sports league. player (pid, pname, age) team(tid, tname, city, cid) coach (cid, cname) members (pid,tid) An instance of the table and an SQL query are given.

$$\begin{array}{} \textbf{player} \\ \begin{array}{|c|c|} \hline \textbf{pid} & \textbf{pname} & \textbf{age} \\ \hline \text{1} & \text{Jasprit} & \text{31} \\ \hline \text{2} & \text{Atharva} & \text{24} \\ \hline \text{3} & \text{Ishan} & \text{26} \\ \hline \text{4} & \text{Axar} & \text{30} \\ \hline \end{array} \\ \end{array} \quad \begin{array}{} \textbf{coach} \\ \begin{array}{|c|c|} \hline \textbf{cid} & \textbf{cname} \\ \hline \text{101} & \text{Ricky} \\ \hline \text{102} & \text{Mark} \\ \hline \text{103} & \text{Trevor} \\ \hline \end{array} \\ \end{array} \quad \begin{array}{} \textbf{team} \\ \begin{array}{|c|c|c|} \hline \textbf{tid} & \textbf{tname} & \textbf{city} & \textbf{cid} \\ \hline \text{10} & \text{MI} & \text{Mumbai} & \text{102} \\ \hline \text{20} & \text{DC} & \text{Delhi} & \text{101} \\ \hline \text{30} & \text{PK} & \text{Mohali} & \text{103} \\ \hline \end{array} \\ \end{array} \quad \begin{array}{} \textbf{members} \\ \begin{array}{|c|c|} \hline \textbf{pid} & \textbf{tid} \\ \hline \text{1} & \text{10} \\ \hline \text{2} & \text{30} \\ \hline \text{3} & \text{10} \\ \hline \text{4} & \text{20} \\ \hline \end{array} \\ \end{array}$$

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)