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

1 vote193 views1 answer
Oracle first row
SQL
2 votes219 views1 answer
Q operator in oracle
SQL
0 vote206 views1 answer
Install squirrel sql ubuntu
SQL
21 votes216 views6 answers
Change column in mysql
SQL
23 votes207 views1 answer
How remove column in mysql
SQL
0 vote209 views2 answers
How to tun mysql on ubunto
SQL
0 vote196 views1 answer
Difference between cross apply and inner join
SQL
2 votes208 views1 answer
Mysql select default if null
SQL
7 votes194 views2 answers
Create index mysql
SQL
0 vote206 views1 answer
Creation d'un trigger sql
SQL