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 userid Sessions WITHOUT a purchase do not.
Tabel contains the following column
EVENTID NUMBER
EVENTTYPE VARCHAR
SESSIONID
SESSIONSEQUENCE NUMBER
TIMESTAMP VARCHAR
USERID NUMBER
IPADDRESS VARCHAR
BROWSER VARCHAR
TRAFFIC SOURCE VARCHAR
SOURCE VARCHAR
URI VARCHAR
CITY VARCHAR
STATE VARCHAR
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
