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

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. · 已于 10 months前审核

great

Jesús E. · 已于 10 months前审核

Rose K. · 已于 10 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前审核

Pelin B. · 已于 11 months前审核

Utku A. · 已于 11 months前审核