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

7 votes109 views4 answers
Index in mysql
SQL
0 vote102 views1 answer
Set default value now() date
SQL
0 vote102 views1 answer
Oracle job schedules
SQL
0 vote109 views2 answers
Connect to mysql server mac terminal
SQL
3 votes100 views1 answer
Mysql set field unique
SQL
1 vote106 views1 answer
Sql oracle update multiple rows
SQL
2 votes144 views1 answer
Orcale index size
SQL
1 vote93 views1 answer
Rename table column name in mysql
SQL
1 vote104 views1 answer
Postgresql escape single quote
SQL
0 vote104 views1 answer
Update one column from another column in same table
SQL