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 vote347 views1 answer
Cahnge column name apex oracle
SQL
0 vote329 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
5 votes315 views1 answer
Oracle create table comment
SQL
0 vote342 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
0 vote333 views1 answer
SQL query to verify the size of the table
SQL
0 vote322 views1 answer
QCompleter con sql
SQL
3 votes338 views5 answers
Duplicate table sql
SQL
1 vote306 views1 answer
Oracle apex prevent initial load
SQL
0 vote326 views1 answer
SQL Server Enterprise
SQL
0 vote332 views1 answer
Sql common columns
SQL