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 vote104 views2 answers
Extract weekday from date in sql
SQL
2 votes95 views1 answer
Install sqlite npm
SQL
5 votes99 views1 answer
Purge undo tablespace oracle 11g
SQL
11 votes106 views6 answers
Mysql else if
SQL
0 vote105 views1 answer
My sql data file extention
SQL
0 vote128 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote56 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote91 views1 answer
Automate mysql cli query
SQL
0 vote93 views1 answer
Dump only schema
SQL
0 vote97 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL