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 vote315 views2 answers
Sql server select where date
SQL
0 vote321 views1 answer
Postgresql where clause not working
SQL
0 vote304 views1 answer
Microsoft word insert sql code
SQL
0 vote315 views1 answer
Sql fetch next 10 rows pdo
SQL
1 vote355 views1 answer
Insert many to many sql
SQL
2 votes374 views2 answers
Null column to 0 in mysql
SQL
0 vote294 views1 answer
Oracle list all stored procedures
SQL
0 vote349 views1 answer
Mysql value ends with
SQL
5 votes347 views3 answers
Postgres show databases
SQL
3 votes337 views1 answer
Uppercase and lowercase in sql
SQL