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

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.capacity