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

13 votes115 views4 answers
Mysql get last row
SQL
0 vote104 views1 answer
Count column of tables psql
SQL
0 vote115 views1 answer
Sql server convert date to weekday
SQL
3 votes130 views1 answer
Postgres add not null to existing column
SQL
1 vote124 views1 answer
How to fetch alternate records from two tables
SQL
0 vote128 views1 answer
Mysql dump for selected row
SQL
4 votes118 views3 answers
Copy table postgres
SQL
0 vote116 views1 answer
Alter table add foreign key mariadb example
SQL
4 votes231 views6 answers
Laravel jwt
SQL
0 vote123 views1 answer
How to alter length character varying postgres
SQL