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

3 votes207 views1 answer
V$session not found in oracle
SQL
8 votes233 views2 answers
Grant all privileges database postgres to user
SQL
1 vote215 views2 answers
Datetrunc hour snowflake
SQL
1 vote234 views1 answer
Isnull sql server
SQL
0 vote216 views1 answer
Knex last insert id mysql
SQL
1 vote195 views3 answers
Remove unique key from a table
SQL
2 votes221 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote225 views1 answer
Pgsql is not permitted to log in
SQL
1 vote222 views2 answers
How to add amount between date in sql
SQL
-1 vote243 views1 answer
How to Activate the database
SQL