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.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)

To determine the value returned by the SQL query, we evaluate it step by step:

1. Subquery Execution: ```sql SELECT M.pid FROM team T, coach C, members M WHERE C.cname = 'Mark' AND T.cid = C.cid AND M.tid = T.tid ```

   • From the coach table, locate the coach with cname = 'Mark'. The corresponding cid is 102.

   • From the team table, join on T.cid = C.cid = 102. The team with cid = 102 is tid = 10 (MI).

   • From the members table, join on M.tid = T.tid = 10. The matching rows are:

     • (pid = 1, tid = 10)

     • (pid = 3, tid = 10)

   • Thus, the subquery returns the set of player IDs: $\{1, 3\}$.

2. Outer Query Execution: ```sqlSELECT MIN(P.age)FROM player P WHERE P.pid IN (1, 3) ```

   • From the player table:

     • For pid = 1 (Jasprit), age = 31.

     • For pid = 3 (Ishan), age = 26.

   • The minimum age among these players is $\min(31, 26) = 26$.

Therefore, the query returns 26.