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

42 votes417 views6 answers
Sql query duplicate rows
SQL
1 vote358 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote343 views1 answer
Sql select min
SQL
1 vote358 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote351 views1 answer
Sql show table name in result
SQL
12 votes320 views2 answers
Delete all data in neo4j
SQL
0 vote358 views1 answer
Suhaib
SQL
0 vote337 views2 answers
How to know the character set of an oracle databes
SQL
0 vote335 views1 answer
Sql delete dastabase
SQL
0 vote324 views2 answers
Database owner can't create new tables postgres
SQL