The Gateway to Computer Science Excellence
0 votes
124 views

 i don't know the actual answer for the question

according to me answer should be A please confirm it

in Databases by Junior (633 points) | 124 views
0
yes my answer is coming A
0
it will give an error.
0

@Utkarsh Joshi

due to there is '=' operator missing in WHERE year 'FY'  ?

otherwise it will give option A.

0
Yes and even student table is missing. They have given table named 'passenger'
0
ok
0

Shaik Masthan inside the inner query they have not included COURSE in from clause so is it valid to access Course relation's attributes in inner query 

0
yes,it is a co-related query
0
okay
+2
If you are not adding the source of question you will be blocked from here. tired of warning people :(
0
Yeah  @ Shaikh it is correlated query

@raja thnxx for answering I got the same answer

1 Answer

+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
by Junior (631 points)
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,737 questions
57,385 answers
198,557 comments
105,369 users