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 vote379 views1 answer
How to select multiple columns from different tables in mysql
SQL
6 votes358 views2 answers
Database url postgres
SQL
0 vote379 views1 answer
SQL Server date literal
SQL
0 vote353 views1 answer
How convert into in in sql query
SQL
1 vote339 views1 answer
Mysql f# examples
SQL
0 vote371 views1 answer
Oracle sql add column auto generated value
SQL
0 vote345 views1 answer
Laravel eloquent get generated sql
SQL
0 vote357 views1 answer
VSCode SQL Server Connection error
SQL
0 vote339 views1 answer
Mysql local password denied
SQL
0 vote357 views1 answer
Mysql query to add hours to column in table
SQL