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 vote258 views1 answer
Replace divide by zero error with 0 in sql
SQL
0 vote240 views1 answer
Drop column from table if exist on live server mysql
SQL
1 vote241 views1 answer
Simple project for database
SQL
0 vote243 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
2 votes227 views1 answer
Check isolation level in mysql
SQL
0 vote221 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote266 views1 answer
Mysql edit trigger
SQL
1 vote246 views1 answer
Hackerrank sql test solutions
SQL
0 vote239 views3 answers
Java hide mysql login credentials
SQL
1 vote234 views1 answer
How to run parallel queries in sql server with entity framework
SQL