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 votes269 views2 answers
Mysql get time from datetime
SQL
0 vote286 views1 answer
Mysql get date diff in months
SQL
3 votes309 views5 answers
Sql select
SQL
2 votes284 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
-1 vote292 views1 answer
Sql show custom constraints
SQL
0 vote288 views1 answer
Get who is hired in month in sql
SQL
0 vote282 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
2 votes265 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote272 views1 answer
Postgres where
SQL
2 votes284 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL