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 vote135 views1 answer
Mysql select inside sum
SQL
1 vote137 views1 answer
Oracle create as select
SQL
1 vote138 views1 answer
Sql try catch
SQL
0 vote126 views1 answer
Report in database
SQL
5 votes130 views2 answers
Copy data from one database to another
SQL
4 votes128 views1 answer
Mysql ip address
SQL
0 vote128 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote125 views1 answer
Check duplicate values plsql
SQL
3 votes252 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote177 views1 answer
Store case result sql
SQL