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

Harsh R. · 已于 over 1 year前审核

Vladyslav I. · 已于 over 1 year前审核

Selvaseelan G. · 已于 over 1 year前审核

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. · 已于 over 1 year前审核

Yuniarto W. · 已于 over 1 year前审核

Arpit G. · 已于 over 1 year前审核

Quite a good SQL lab.

Arnel Perez P. · 已于 over 1 year前审核

Esteban Daniel M. · 已于 over 1 year前审核

great

Jesús E. · 已于 over 1 year前审核

Rose K. · 已于 over 1 year前审核

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. · 已于 over 1 year前审核

Great learning session

Martijn V. · 已于 over 1 year前审核

Lautaro R. · 已于 over 1 year前审核

Scott K. · 已于 over 1 year前审核

Imy Y. · 已于 over 1 year前审核

Shyam Kumar K. · 已于 over 1 year前审核

Hamza B. · 已于 over 1 year前审核

fun

martian t. · 已于 over 1 year前审核

GRANDHE Y. · 已于 over 1 year前审核

David L. · 已于 over 1 year前审核

Fabian W. · 已于 over 1 year前审核

Íñigo d. · 已于 over 1 year前审核

Saranya N. · 已于 over 1 year前审核

Muhammad y. · 已于 over 1 year前审核

Miguel Eduardo A. · 已于 over 1 year前审核