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 vote131 views1 answer
Sql update subtract value
SQL
2 votes130 views3 answers
How to get second highest salary in each department in sql
SQL
3 votes150 views5 answers
Foreign keys
SQL
0 vote124 views1 answer
C# datetime to sql server datetime
SQL
3 votes162 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote123 views1 answer
What alter does in db
SQL
0 vote127 views1 answer
Mysql 5.7 in centos 7
SQL
0 vote84 views1 answer
Mysql find foreign key references
SQL
-1 vote83 views1 answer
Mysql how to set update or create
SQL
0 vote136 views1 answer
Create table with float datatype in sql server
SQL