Question: SQL Write a query to find out what was the average # of events in sessions with a purchase? A session is a user's trip,

SQL Write a query to find out what was the average # of events in sessions with a purchase?
A session is a user's trip, their entire trip, to the website, and it typically includes multiple events. Sessions WITH a purchase have a user_id. Sessions WITHOUT a purchase do not.
Tabel contains the following column
EVENT_ID NUMBER(38,0)
EVENT_TYPE VARCHAR (16777216)
SESSION_ID (16777216)
SESSION_SEQUENCE NUMBER (38,0)
TIMESTAMP VARCHAR (16777216)
USER_ID NUMBER(38,0)
IP_ADDRESS VARCHAR (16777216)
BROWSER VARCHAR (16777216)
TRAFFIC_ SOURCE VARCHAR (16777216)
SOURCE VARCHAR (16777216)
URI VARCHAR (16777216)
CITY VARCHAR (16777216)
STATE VARCHAR (16777216)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!