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 vote137 views1 answer
How to to get current date in sql
SQL
0 vote277 views2 answers
Create fulltext index mysql
SQL
-1 vote93 views1 answer
Mysql how to set update or create
SQL
1 vote152 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote135 views1 answer
Set column in all row mysql
SQL
5 votes172 views2 answers
Functions
SQL
0 vote134 views1 answer
Mysql drop trigger
SQL
0 vote145 views1 answer
Mysql c commands
SQL
17 votes160 views4 answers
Mysql remove ubuntu
SQL
6 votes125 views2 answers
How to copy data in sql
SQL