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 vote124 views1 answer
Add colum date in sql
SQL
0 vote169 views1 answer
Count column of tables psql
SQL
1 vote149 views3 answers
Sql procedure
SQL
0 vote124 views1 answer
Postgres call view
SQL
2 votes165 views1 answer
Oracle log files
SQL
0 vote120 views1 answer
Mysql change default collation
SQL
5 votes124 views5 answers
Find max number in sql
SQL
0 vote131 views1 answer
How to import sqlite driver class in java using maven
SQL
3 votes131 views2 answers
Truncate table
SQL
0 vote164 views1 answer
Update sql sintax
SQL