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 vote189 views1 answer
Reindexing all tables sql server
SQL
6 votes146 views3 answers
Mysql server is not starting xampp
SQL
0 vote145 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote139 views1 answer
Sql view index
SQL
3 votes147 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote146 views1 answer
Fast sql column count
SQL
8 votes144 views2 answers
Phpmyadmin default password
SQL
1 vote147 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote111 views1 answer
Java spring jdbc connect to postgresql
SQL
16 votes175 views3 answers
Get count of duplicate records
SQL