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

2 votes361 views1 answer
Set username and password for postgresql database
SQL
5 votes385 views1 answer
Mysql last day of next month
SQL
0 vote384 views1 answer
Load data from text file to mysql database on mac terminal
SQL
2 votes337 views3 answers
Replace null in sql
SQL
0 vote349 views1 answer
Oracle c# multiple update sql
SQL
0 vote391 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote406 views1 answer
How to set up an anonymous function to variable in swift
SQL
1 vote326 views1 answer
Sql auto timestamp
SQL
18 votes362 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
1 vote351 views1 answer
Alter table column size oracle
SQL