Subquery aggregation

select name, revenue from (
	select facs.name, sum(case 
				when memid = 0 then slots * facs.guestcost
				else slots * membercost
			end) as revenue
		from cd.bookings bks
		inner join cd.facilities facs
			on bks.facid = facs.facid
		group by facs.name
	) as agg where revenue < 1000
order by revenue;

Source: pgexercises.com

Similar codes

0 vote248 views4 answers
Sql year
SQL
6 votes254 views2 answers
Where clause in sql
SQL
1 vote245 views1 answer
Sql bitwise operators
SQL
0 vote313 views1 answer
Sql server query all database objects
SQL
3 votes272 views1 answer
Sql case update
SQL
1 vote223 views1 answer
Enable mysql slow query log
SQL
1 vote273 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote263 views1 answer
Pl/ sql change currency
SQL
0 vote259 views1 answer
Date on SQL
SQL
6 votes247 views1 answer
What is where clause in sql
SQL