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 vote304 views1 answer
Sql server convert to guid
SQL
1 vote287 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote325 views1 answer
Alter table change default
SQL
0 vote311 views1 answer
Postgres regex word boundary
SQL
1 vote331 views1 answer
Encrypt password postgresql
SQL
1 vote308 views3 answers
Rows, INSERT INTO
SQL
0 vote313 views2 answers
Script all indexes in a database
SQL
10 votes298 views1 answer
User_dependencies
SQL
0 vote292 views1 answer
Pgadmin see indexes
SQL
0 vote285 views1 answer
Display first three characters sql
SQL