I need an SQL query that is scalable
- or -
Post a project like this1800
£20(approx. $25)
- Posted:
- Proposals: 4
- Remote
- #2387616
- Awarded
Description
Experience Level: Intermediate
Hallo All!
I need an SQL query with the below characteristics:
--------------------------------------------------
One SQL query to create a cohort of Signup to First Order and show the result. The objective of this cohort is to see, out of the users that signed up in Week N, how many did their first order in Week N+1, N+2, N+3...
As an input, you have 2 tables :
- one with user_id, signup_timestamp
- and a second one with user_id, order_timestamp
Make it scalable.
--------------------------------------------------
Thank you !
I need an SQL query with the below characteristics:
--------------------------------------------------
One SQL query to create a cohort of Signup to First Order and show the result. The objective of this cohort is to see, out of the users that signed up in Week N, how many did their first order in Week N+1, N+2, N+3...
As an input, you have 2 tables :
- one with user_id, signup_timestamp
- and a second one with user_id, order_timestamp
Make it scalable.
--------------------------------------------------
Thank you !
Dion A.
100% (2)Projects Completed
1
Freelancers worked with
1
Projects awarded
33%
Last project
9 May 2019
Switzerland
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies