GATE CS 2025 (Forenoon) — Question 55

Database Management Systems (DBMS)SQL Queries (DDL/DML, Joins, Aggregations)NAT2 marksMedium

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.
Question image
sql
1SELECT MIN(P.age)
2FROM player P
3WHERE P.pid IN (
4    SELECT M.pid
5    FROM team T, coach C, members M
6    WHERE C.cname = 'Mark'
7        AND T.cid = C.cid
8        AND M.tid = T.tid
9)
10
The value returned by the given SQL query is ________. (Answer in integer)
Practise the full 2025-FN paper
Challenge a friend: WhatsApp Telegram
Recommended book · affiliate linkDatabase System Concepts (Korth)Normalisation, SQL, transactions and indexing — the DBMS syllabus in one book.
Practise more on SQL Queries (DDL/DML, Joins, Aggregations)Timed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group