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 vote280 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote311 views1 answer
Oracle session statistics
SQL
0 vote281 views1 answer
Partitioning in oracle-base
SQL
0 vote311 views1 answer
Sql: extract day text from datetime value
SQL
6 votes309 views4 answers
Mysql group by month
SQL
-2 votes280 views3 answers
Oracle tablespace usage
SQL
1 vote280 views1 answer
Apex select list ORA-20999
SQL
2 votes286 views4 answers
Mysql select into new table
SQL
0 vote301 views1 answer
Tsql delete all rows
SQL
3 votes292 views2 answers
MySQL query to get column names
SQL