Exploring an Ecommerce Dataset using SQL in Google BigQuery Reviews

Riya C. · Reviewed 1 yıldan fazla ago

Harsh R. · Reviewed 1 yıldan fazla ago

Vladyslav I. · Reviewed 1 yıldan fazla ago

Selvaseelan G. · Reviewed 1 yıldan fazla 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 yıldan fazla ago

Yuniarto W. · Reviewed 1 yıldan fazla ago

Arpit G. · Reviewed 1 yıldan fazla ago

Quite a good SQL lab.

Arnel Perez P. · Reviewed 1 yıldan fazla ago

Esteban Daniel M. · Reviewed 1 yıldan fazla ago

great

Jesús E. · Reviewed 1 yıldan fazla ago

Rose K. · Reviewed 1 yıldan fazla 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 yıldan fazla ago

Great learning session

Martijn V. · Reviewed 1 yıldan fazla ago

Lautaro R. · Reviewed 1 yıldan fazla ago

Scott K. · Reviewed 1 yıldan fazla ago

Imy Y. · Reviewed 1 yıldan fazla ago

Shyam Kumar K. · Reviewed 1 yıldan fazla ago

Hamza B. · Reviewed 1 yıldan fazla ago

fun

martian t. · Reviewed 1 yıldan fazla ago

GRANDHE Y. · Reviewed 1 yıldan fazla ago

David L. · Reviewed 1 yıldan fazla ago

Fabian W. · Reviewed 1 yıldan fazla ago

Íñigo d. · Reviewed 1 yıldan fazla ago

Saranya N. · Reviewed 1 yıldan fazla ago

Muhammad y. · Reviewed 1 yıldan fazla ago