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

28 votes280 views4 answers
Delete database mysql
SQL
1 vote274 views1 answer
Postgres killing connections on db
SQL
4 votes253 views2 answers
Sql select except null
SQL
0 vote270 views1 answer
Java check if something is in mysql table
SQL
0 vote276 views1 answer
Second Step in installing SQL workbench
SQL
0 vote263 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
1 vote255 views1 answer
What is intersect
SQL
1 vote262 views1 answer
Mysql show long running queries
SQL
0 vote254 views1 answer
Default column value in sql same as other column
SQL
0 vote259 views1 answer
H2 auto increment and unique
SQL