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 vote183 views1 answer
Heavy table in mysql
SQL
0 vote190 views1 answer
Mysql a from on this page has
SQL
0 vote194 views1 answer
Mysql return column names when table is empty
SQL
0 vote190 views1 answer
Implicit inner join table alias with id values
SQL
0 vote170 views1 answer
If exist column in table drop sql query mysql
SQL
1 vote218 views1 answer
Mysql search like order by best match
SQL
1 vote177 views1 answer
Get count by weekly pivot table sql server
SQL
1 vote197 views2 answers
Restart identity cascade
SQL
0 vote215 views1 answer
Transalations from sql to Linq count and group by
SQL
1 vote185 views2 answers
Mysql extract month
SQL