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 vote99 views1 answer
Search In the Database using Text
SQL
0 vote104 views1 answer
Mysql remove tabs from string
SQL
2 votes101 views1 answer
Mysql how to store lat,lng
SQL
2 votes114 views1 answer
Oracle convert run_duration to number
SQL
0 vote111 views1 answer
Jdbc sql connection string
SQL
0 vote183 views1 answer
Sql if clause within where clause
SQL
0 vote111 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote122 views1 answer
What logs are available on RDS MySQL?
SQL
1 vote110 views1 answer
Oracle index partition
SQL
-1 vote114 views1 answer
Count occurrences sql
SQL