# MadeEasy Test Series: Databases - Sql

192 views

I got why query 2 is wrong. How do I approach to understand Query 1, is there a generic approach for solving questions like these which have no tables given?

edited
3
First of all It is a co-related sub query . Now as you can observe , the NOT EXISTS clause is used . So the outer query will print a tuple if and only if the inner query returns nothing .

That is if at least one person who is of age less than 22 , and has rating greater than or equal to the rating of the sailor of the outer query , then the outer query shall not print anything .

So only if there is no such sailor whose age is less than 22 , and has rating greater than or equal to some sailor of the outer query , only then a sailor name shall be printed .
0

@amitqy bro if you have enough practice then you can apply what @prashant jha 1 said ,otherwise solve it by taking a small table by yourself.

## Related questions

1
300 views
$Emp$ $(eid: integer, ename: string, age: integer, salary :real)$ $Works$ $(eid: integer, did: integer, pct_time: integer)$ $Dept$ $(did: integer, budget: real, managerid: integer)$ $CREATE$ $VIEW$ $AvgsalaryByAge (age, AvgSalary) AS$ ... updated automatically. The above view on Emp can be updated automatically by updating Emp. The above view cannot be created automatically. None of the above