Exploring an Ecommerce Dataset using SQL in Google BigQuery Reviews

Harsh R. · Reviewed 10 أشهر ago

Vladyslav I. · Reviewed 10 أشهر ago

Selvaseelan G. · Reviewed 10 أشهر 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 10 أشهر ago

Yuniarto W. · Reviewed 10 أشهر ago

Arpit G. · Reviewed 11 شهر ago

Quite a good SQL lab.

Arnel Perez P. · Reviewed 11 شهر ago

Esteban Daniel M. · Reviewed 11 شهر ago

great

Jesús E. · Reviewed 11 شهر ago

Rose K. · Reviewed 11 شهر 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 شهر ago

Great learning session

Martijn V. · Reviewed 11 شهر ago

Lautaro R. · Reviewed 11 شهر ago

Scott K. · Reviewed 11 شهر ago

Imy Y. · Reviewed 11 شهر ago

Shyam Kumar K. · Reviewed 11 شهر ago

Hamza B. · Reviewed 11 شهر ago

fun

martian t. · Reviewed 11 شهر ago

GRANDHE Y. · Reviewed 11 شهر ago

David L. · Reviewed 11 شهر ago

Fabian W. · Reviewed 11 شهر ago

Íñigo d. · Reviewed 11 شهر ago

Saranya N. · Reviewed 11 شهر ago

Muhammad y. · Reviewed 11 شهر ago

Miguel Eduardo A. · Reviewed 11 شهر ago