PostgreSQL | PGExercises.com | Rank by revenue

-- https://pgexercises.com/questions/aggregates/facrev3.html

with t1 as(
    select name, sum(slots * case when memid=0 then guestcost else membercost end) as revenue
    from cd.bookings b
    join cd.facilities f
    on f.facid = b.facid
    group by 1
    order by 2 desc)

select name, rank() over(order by revenue desc)
from t1
limit 3