I am not sure wichi is correct answer. Beacuse the same question is repeted twice.
1st time i entered as 0 and answer was wrong.
2nd time i entered as 1 still anser was wrong saying it is 0
is this a valid question ?
You have made a small reading mistake. The same question is not repeated twice; there is one small but important difference. The "first" question uses ANY, whereas the "second" (this) question uses ALL. These two keywords modify the meaning of the subquery in different ways; for that reason the question with ANY had 1 as the correct answer, and the question with ALL has 0 as the correct answer.
Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis