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 vote339 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote326 views1 answer
Sql server alter table add column tinyint
SQL
5 votes285 views1 answer
List foreign key oracle
SQL
9 votes340 views3 answers
Where clause sql
SQL
1 vote336 views1 answer
Sql how to replace full stop
SQL
3 votes310 views2 answers
Get current year sql
SQL
2 votes256 views2 answers
Mysql get last character of string
SQL
2 votes288 views1 answer
Sql find missing values between two tables
SQL
0 vote309 views1 answer
Sql DATE = GETDATE()
SQL
0 vote310 views1 answer
Mysql min value row
SQL