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 vote380 views2 answers
Mysql get day of week
SQL
29 votes340 views6 answers
Delete all rows from table mysql
SQL
2 votes381 views1 answer
Mysql id of inserted row
SQL
18 votes352 views6 answers
Laravel form validation
SQL
0 vote341 views1 answer
Console output pl sql
SQL
0 vote410 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote372 views2 answers
While mysql
SQL
8 votes322 views2 answers
Alter column name in mssql
SQL
0 vote332 views1 answer
Opensuse start MySQL
SQL
0 vote333 views1 answer
Call function sql oracle
SQL