SQL

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.

player                  coach            team                         members
pid  pname    age       cid  cname       tid  tname  city    cid      pid  tid
1    Jasprit  31        101  Ricky       10   MI     Mumbai  102      1    10
2    Atharva  24        102  Mark        20   DC     Delhi   101      2    30
3    Ishan    26        103  Trevor      30   PK     Mohali  103      3    10
4    Axar     30                                                      4    20

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)

Consider the following relational schema:

Students (rollno: integer, name: string, age: integer, cgpa: real)
Courses (courseno: integer, cname: string, credits: integer)
Enrolled (rollno: integer, courseno: integer, grade: string)

Which of the following options is/are correct SQL query/queries to retrieve the names of the students enrolled in course number (i.e., courseno) 1470?