644 views
0 votes
0 votes

 i don't know the actual answer for the question

according to me answer should be A please confirm it

1 Answer

2 votes
2 votes
Here query is co-related

So, for one external query examine an internal query

taking  sid from student ,sid = 0

year = FY exist but age == 16 : False (not come in final output)(not > 16)

You can check manually for each sid

final output ( 1,2,3)

Correct Anser A

Related questions

1 votes
1 votes
1 answer
1
Shubhanshu asked Dec 24, 2018
1,256 views
According to me it should be – “Retrieve the names of all students with a lower rank, than all students with age < 18 ”
0 votes
0 votes
0 answers
2
Tuhin Dutta asked Dec 15, 2017
397 views
Student tableROLLNONAMEMARKS1MARKS21T50302S70993DNULL10NULLNULL78NULLNULLNULLNULLNULLa) select count(MARKS1) from student;b) select count(*) from student;
0 votes
0 votes
0 answers
3