Databases · SQL
Official IIT answer key · IIT Guwahati · Audited Aug 2026
GATE CSE 2025 Set 1 Q55 · NAT · 2 marks
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)
Key concept
Topic notes
In GATE CS, SQL is tested through a balanced mix of declarative query semantics, relational-algebra correspondence, subquery evaluation (correlated, nested, and universal quantification), and instance-level tracing. Questions range from conceptual integrity rules (DDL constraints, FOREIGN KEY targets, GROUP BY/HAVING rules) to practical computation of output row counts and aggregate values on small database instances. Recent papers strongly emphasize NAT execution traces and multi-correct (MSQ) equivalent query formulations.
Full SQL guide →Independent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.