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 vote260 views4 answers
Full outer join in sql
SQL
0 vote216 views1 answer
Convert excel into sqllite db using python
SQL
0 vote196 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote204 views1 answer
Less mysql display
SQL
2 votes198 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
1 vote183 views1 answer
Media sql
SQL
0 vote192 views1 answer
How to select all fieldsin a soql query
SQL
0 vote188 views2 answers
Find Overlapping sql
SQL
1 vote199 views1 answer
Install postgresql on raspberry pi
SQL
1 vote204 views2 answers
Snowflake alter column data type
SQL