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

2 votes261 views1 answer
Postgresql format date dd/mm/yyyy
SQL
1 vote292 views1 answer
Table valued functions in sql
SQL
11 votes291 views5 answers
Laravel db facade
SQL
0 vote290 views1 answer
Postgres regex word boundary
SQL
0 vote226 views1 answer
Oracle sql developer script output limit
SQL
8 votes312 views6 answers
Insert command in sql
SQL
1 vote285 views1 answer
Oracle drop job if exists
SQL
7 votes275 views5 answers
Show details of table postgres
SQL
0 vote291 views1 answer
Check if a column is a primary key in sql server
SQL
1 vote272 views1 answer
Postgres first_value in gropby
SQL