Exploring an Ecommerce Dataset using SQL in Google BigQuery avis

Abhishek K. · Examiné il y a environ un an

Three are a several issues. 1. it asks is the highest visited product also the highest number of orders. the answer is YES, but i was marked wrong because it meant to ask is the product with the highest visitors the most ordered units of a product. 2. practice question 1. uses, productQuantity as a count for add to carts and sum for orders. however that was never defined. Additionally it doesn't call out that ecommerceAction_type =3 is add to cart until way after that question is asked. Same for question number 2, the answer is part of 2b. The practice questions omit information that should be part of the question so that we have a fighting chance of answering it. asking for add to carts and then hiding the data in a type = 3 is just wrong.

Eric L. · Examiné il y a environ un an

Easy, clear and fast

Antonio D. · Examiné il y a environ un an

Kiran B. · Examiné il y a environ un an

Théo H. · Examiné il y a environ un an

Gesiane D. · Examiné il y a environ un an

Antonio L. · Examiné il y a environ un an

Thomas C. · Examiné il y a environ un an

Dillibabu P. · Examiné il y a environ un an

Karan R. · Examiné il y a environ un an

URAIRAT J. · Examiné il y a environ un an

Liliya C. · Examiné il y a environ un an

Vijay P. · Examiné il y a environ un an

Faith M. · Examiné il y a environ un an

Jordan V. · Examiné il y a environ un an

Leon Victor M. · Examiné il y a environ un an

Polina P. · Examiné il y a environ un an

Marcos C. · Examiné il y a environ un an

Nicolas M. · Examiné il y a environ un an

Samuel H. · Examiné il y a environ un an

3

Adi I. · Examiné il y a environ un an

Christian M. · Examiné il y a environ un an

Josep C. · Examiné il y a environ un an

Steve P. · Examiné il y a environ un an

Alejandro R. · Examiné il y a environ un an