Breaking News: Grepper is joining You.com. Read the official announcement!

subquery aggregation

Handsome Hawk answered on August 25, 2021 Popularity 3/10 Helpfulness 1/10

answer subquery aggregation

subquery aggregation

Comment

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;

Popularity 3/10 Helpfulness 1/10 Language sql

Source: pgexercises.com

Tags: aggregation sql subquery

Link to this answer
Share Copy Link

Contributed on Aug 25 2021

Handsome Hawk

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

subquery aggregation

Contents

More Related Answers

subquery aggregation

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.