Exploring an Ecommerce Dataset using SQL in Google BigQuery Reviews

Alex S. · Reviewed 10 months ago

Jennifer P C. · Reviewed 10 months ago

Riya C. · Reviewed 10 months ago

Harsh R. · Reviewed 10 months ago

Vladyslav I. · Reviewed 11 months ago

Selvaseelan G. · Reviewed 11 months 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 11 months ago

Yuniarto W. · Reviewed 11 months ago

Arpit G. · Reviewed 11 months ago

Quite a good SQL lab.

Arnel Perez P. · Reviewed 11 months ago

Esteban Daniel M. · Reviewed 11 months ago

great

Jesús E. · Reviewed 11 months ago

Rose K. · Reviewed 11 months 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 11 months ago

Great learning session

Martijn V. · Reviewed 11 months ago

Lautaro R. · Reviewed 11 months ago

Scott K. · Reviewed 11 months ago

Imy Y. · Reviewed 11 months ago

Shyam Kumar K. · Reviewed 11 months ago

Hamza B. · Reviewed 11 months ago

fun

martian t. · Reviewed 11 months ago

GRANDHE Y. · Reviewed 11 months ago

David L. · Reviewed 11 months ago

Fabian W. · Reviewed 11 months ago

Íñigo d. · Reviewed 11 months ago