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 vote134 views1 answer
Order by monthly in sql
SQL
0 vote131 views2 answers
Show slave status mysql
SQL
0 vote152 views1 answer
Mysql group by derived column
SQL
11 votes96 views1 answer
Reset identity sql server
SQL
1 vote153 views2 answers
Restart identity cascade
SQL
0 vote139 views1 answer
How to install postgresql on wsl
SQL
0 vote174 views1 answer
Find wordpress version in database
SQL
-1 vote153 views2 answers
Mysql get day of week
SQL
1 vote152 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
1 vote166 views1 answer
Sql and
SQL