Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q 1 ) write postgresql code In the last 7 days how many users made more than one purchase in a day ( per day

Q1) write postgresql code
In the last 7 days how many users made more than one purchase in a day (per day)? What is the total daily revenue from such users? Please arrange the output by date
The output will have 7 rows and 3 columns: Date, total revenue, unique users
Table Name: purchase info
\table[[User_id,Action,date purchase_type,dollar_amount,purchase_id],[abc,purchase_complete,2020-06-10 Gold,1.00,xt246],[abc,purchase_complete,2020-06-11 Gold,1.00,xy239]]
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing Fundamentals Design

Authors: Marion Donnie Dutton Don F. Seaman

14th Edition Globel Edition

1292107634, 978-1292107639

More Books

Students also viewed these Databases questions

Question

What is the bookkeeping entry for a withdrawal of owner's capital?

Answered: 1 week ago

Question

Conduct a needs assessment. page 269

Answered: 1 week ago