virtualgate

Question

Here query is not correct if there are two persons with higher rating?Am I correct?

Comments

query in the last table returned null because age of all people were < 21.

---

@manu sir

In the question, it is given "names of sailors". Shouldn't that allow the sailors to be more than 1 (equality allowed?)

---

Query one is correct. 

Answer 1

what will be the output?

                sailors

sid    sage srating

a5     20     5

a2     19     4

a1     18     3

 

I think answer should be null even a5 has rating higher than all sailors with age<21 according to querry 1. INCORRECT QUERRY 1???