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

3 votes188 views2 answers
Create schema postgres
SQL
0 vote176 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
0 vote177 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
3 votes232 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
5 votes199 views2 answers
Postgresql add not null constraint
SQL
0 vote179 views1 answer
Match end of string regex sql
SQL
0 vote215 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote187 views1 answer
Select row with latest date mysql
SQL
1 vote197 views1 answer
Denied
SQL
0 vote176 views1 answer
Mysql count by month
SQL