Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Microsoft SQL Server 2012 Unleashed

Authors: Ray Rankins, Paul Bertucci

1st Edition

0133408507, 9780133408508

More Books

Students also viewed these Databases questions

Question

3. What are potential solutions?

Answered: 1 week ago