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 vote172 views1 answer
How to add boolean column in postgresql
SQL
0 vote177 views1 answer
Apex for oracle 11g
SQL
1 vote171 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
2 votes175 views1 answer
Oracle to_char number format percentage
SQL
0 vote165 views1 answer
Update view sql
SQL
0 vote184 views1 answer
Update database collation in postgresql
SQL
0 vote184 views1 answer
Mysql milliseconds
SQL
0 vote216 views1 answer
Insert into using contant values and source table columns with sql
SQL
8 votes206 views6 answers
Insert command in sql
SQL
12 votes171 views3 answers
Install sqlite driver ubuntu
SQL