关于“Exploring an Ecommerce Dataset using SQL in Google BigQuery”的评价

Vladyslav I. · 评论10 months之前

Selvaseelan G. · 评论10 months之前

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. · 评论10 months之前

Yuniarto W. · 评论10 months之前

Arpit G. · 评论10 months之前

Quite a good SQL lab.

Arnel Perez P. · 评论10 months之前

Esteban Daniel M. · 评论11 months之前

great

Jesús E. · 评论11 months之前

Rose K. · 评论11 months之前

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. · 评论11 months之前

Great learning session

Martijn V. · 评论11 months之前

Lautaro R. · 评论11 months之前

Scott K. · 评论11 months之前

Imy Y. · 评论11 months之前

Shyam Kumar K. · 评论11 months之前

Hamza B. · 评论11 months之前

fun

martian t. · 评论11 months之前

GRANDHE Y. · 评论11 months之前

David L. · 评论11 months之前

Fabian W. · 评论11 months之前

Íñigo d. · 评论11 months之前

Saranya N. · 评论11 months之前

Muhammad y. · 评论11 months之前

Miguel Eduardo A. · 评论11 months之前

yusdene b. · 评论11 months之前