Consider the following database table named water_schemes: The number of…
PYQ GATE 2016
Consider the following database table named water_schemes:

The number of tuples returned by the following SQL query is _____________ .
with total(name, capacity) as
select district_name, sum(capacity)
from water_schemes
group by district_name
with total_avg(capacity) as
select avg(capacity)
from total
select name
from total, total_avg
where total.capacity ≥ total_avg.capacityAttempted by 131 students.
Sign up free to check your answer
Sign up freeLoading lesson…

