Q60Section DA (Data Science and Artificial Intelligence (Q11–Q65))60 of 65
Counting rows returned by a rank-comparison SQL query
Let Account be a relation as shown.
| AccNo | Balance | |—|—| | A1 | 5000 | | A2 | 5000 | | A3 | 10000 | | A4 | 15000 | | A5 | 18000 |
Consider the given SQL query.
SELECT AccNo FROM Account AS A
WHERE (SELECT COUNT(*) FROM Account AS B
WHERE A.Balance < B.Balance) >= (SELECT COUNT(*)
FROM Account AS C WHERE A.Balance > C.Balance)
The number of rows returned by the SQL query is __________ . (Answer in integer)
Numerical answer: type the number (no options).
Type your answer and check it.