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 vote208 views1 answer
Customer using hdfc bank sql query
SQL
0 vote173 views1 answer
Oracle date summer time
SQL
41 votes217 views6 answers
Alter table add column in SQL Server
SQL
0 vote195 views1 answer
Write a query to peint the pattern P(20)
SQL
3 votes177 views2 answers
Postgres alter table owner
SQL
0 vote208 views1 answer
Get substract count sql
SQL
0 vote193 views1 answer
Mysql get only the field names in a table
SQL
8 votes172 views2 answers
Phpmyadmin default password
SQL
0 vote193 views1 answer
Prodection ready postgres database step by step
SQL
0 vote168 views1 answer
Oracle create package body
SQL