Average revenue for past 15 days in sql

Red Team answered on September 24, 2024 Popularity 1/10 Helpfulness 1/10

answer Average revenue for past 15 days in sql

Average revenue for past 15 days in sql

Comment

select 	dategen.date,
	(
		-- correlated subquery that, for each day fed into it,
		-- finds the average revenue for the last 15 days
		select sum(case
			when memid = 0 then slots * facs.guestcost
			else slots * membercost
		end) as rev

		from cd.bookings bks
		inner join cd.facilities facs
			on bks.facid = facs.facid
		where bks.starttime > dategen.date - interval '14 days'
			and bks.starttime < dategen.date + interval '1 day'
	)/15 as revenue
	from
	(
		-- generates a list of days in august
		select 	cast(generate_series(timestamp '2012-08-01',
			'2012-08-31','1 day') as date) as date
	)  as dategen
order by dategen.date;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: pgexercises.com

Tags: average days revenue sql

Link to this answer
Share Copy Link

Contributed on Sep 24 2024

Red Team

0 Answers Avg Quality 2/10

Average revenue for past 15 days in sql

Contents

More Related Answers

Average revenue for past 15 days in sql

Grepper

Documentation

Social

Legal

Contact

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