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 vote187 views1 answer
Calculate date and convert to yearsmysql
SQL
8 votes194 views2 answers
Alert table name mysql
SQL
0 vote197 views1 answer
Resullt all update knex mysql
SQL
1 vote210 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote204 views1 answer
How to install postgresql on wsl
SQL
-1 vote226 views2 answers
Sql truncate number
SQL
18 votes185 views3 answers
Mysql query add column with default string value
SQL
3 votes200 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
5 votes203 views3 answers
Sql max value in column
SQL
0 vote202 views1 answer
Restart sql server command line linux
SQL