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 vote226 views1 answer
Mysql is odd
SQL
0 vote363 views1 answer
Sql datum formatieren
SQL
7 votes145 views6 answers
Group_concat mysql
SQL
4 votes154 views2 answers
Sql server date now
SQL
0 vote163 views1 answer
Mysql average from two table
SQL
10 votes148 views2 answers
Linux command line import mysql database
SQL
1 vote170 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
1 vote145 views4 answers
Between vs in sql
SQL
16 votes162 views3 answers
Jwt secret key generator laravel
SQL
1 vote148 views2 answers
Grab part of a string sql
SQL