Exploring an Ecommerce Dataset using SQL in Google BigQuery Reviews

Terrence J. · Reviewed over 1 year ago

Tariel B. · Reviewed over 1 year ago

Alex S. · Reviewed over 1 year ago

Jennifer P C. · Reviewed over 1 year ago

Riya C. · Reviewed over 1 year ago

Harsh R. · Reviewed over 1 year ago

Vladyslav I. · Reviewed over 1 year ago

Selvaseelan G. · Reviewed over 1 year ago

Last possible solution is weird, there are people who added product and had other actions (remove product) whom we have to count Lab is too easy and giving all the solutions

Irina P. · Reviewed over 1 year ago

Yuniarto W. · Reviewed over 1 year ago

Arpit G. · Reviewed over 1 year ago

Quite a good SQL lab.

Arnel Perez P. · Reviewed over 1 year ago

Esteban Daniel M. · Reviewed over 1 year ago

great

Jesús E. · Reviewed over 1 year ago

Rose K. · Reviewed over 1 year ago

I think for the last query, since a particular unique_session_id can have a cart addition and a removal, this query might be better: select concat(fullVisitorId, cast(visitId as string)) as unique_session_id , sessionQualityDim from `data-to-insights.ecommerce.all_sessions` where sessionQualityDim > 60 and eCommerceAction_type = '3' group by 1,2 having SUM(transactionRevenue) is null or SUM(transactionRevenue) = 0

Shreya G. · Reviewed over 1 year ago

Great learning session

Martijn V. · Reviewed over 1 year ago

Lautaro R. · Reviewed over 1 year ago

Scott K. · Reviewed over 1 year ago

Imy Y. · Reviewed over 1 year ago

Shyam Kumar K. · Reviewed over 1 year ago

Hamza B. · Reviewed over 1 year ago

fun

martian t. · Reviewed over 1 year ago

GRANDHE Y. · Reviewed over 1 year ago

David L. · Reviewed over 1 year ago