Exploring an Ecommerce Dataset using SQL in Google BigQuery Reviews

Riya C. · Reviewed больше 1 года ago

Harsh R. · Reviewed больше 1 года ago

Vladyslav I. · Reviewed больше 1 года ago

Selvaseelan G. · Reviewed больше 1 года 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 больше 1 года ago

Yuniarto W. · Reviewed больше 1 года ago

Arpit G. · Reviewed больше 1 года ago

Quite a good SQL lab.

Arnel Perez P. · Reviewed больше 1 года ago

Esteban Daniel M. · Reviewed больше 1 года ago

great

Jesús E. · Reviewed больше 1 года ago

Rose K. · Reviewed больше 1 года 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 больше 1 года ago

Great learning session

Martijn V. · Reviewed больше 1 года ago

Lautaro R. · Reviewed больше 1 года ago

Scott K. · Reviewed больше 1 года ago

Imy Y. · Reviewed больше 1 года ago

Shyam Kumar K. · Reviewed больше 1 года ago

Hamza B. · Reviewed больше 1 года ago

fun

martian t. · Reviewed больше 1 года ago

GRANDHE Y. · Reviewed больше 1 года ago

David L. · Reviewed больше 1 года ago

Fabian W. · Reviewed больше 1 года ago

Íñigo d. · Reviewed больше 1 года ago

Saranya N. · Reviewed больше 1 года ago

Muhammad y. · Reviewed больше 1 года ago