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 table

coach table:

team table:

members table:

SQL query: \[ {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)

Hint:

To solve SQL queries involving JOIN operations between multiple tables, ensure that you carefully follow the relationships between the tables (e.g., matching \( cid \) and \( tid \) between coach, team, and members tables) and identify which rows satisfy the conditions.

Answer 1

Correct Answer: 26

The query ultimately evaluates the ages of players associated with teams that are linked to a specific coach. Only those players who belong to teams coached by Mark are considered.

Among all such players, the query applies an aggregate condition that selects the smallest age value.

Inspecting the relevant player records that satisfy this condition shows that the youngest eligible player is Ishan, whose age is \(26\).

Therefore, the value returned by the SQL query is \(\boxed{26}\).