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

5 votes182 views1 answer
Find table from column name in sql
SQL
7 votes164 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote241 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote179 views3 answers
Duplicate row mysql
SQL
2 votes156 views1 answer
Oracle kill job by sid
SQL
0 vote331 views1 answer
Install mysql on bash
SQL
0 vote178 views1 answer
C# execute transact sql
SQL
0 vote158 views1 answer
Sql date between one week
SQL
7 votes183 views2 answers
Where keyword sql
SQL
0 vote192 views1 answer
Sql server insert inner join
SQL