Amazon SQL Interview Questions: Lead Data Analyst Solves Complex E-Commerce SQL Problem

[@iqjayfeng]

Want to ace your data science interview? 🚀 85% of successful candidates practice with real interview questions. Explore the ones companies actually ask: www.interviewquery.com/questions?

[@rishankijain]

If I simply focus on the immediate query we can enhance it by the following - Currently categories/order as a metric is not sufficient. It blinds us to any outliers. We can also look at number of orders/users and create cohorts based on range of low intent to high intent consumers on the platform. This way we would remove those 1 and done's or users who might have hit multiple categories in one order but maybe just 1 category in another order. And then use this data for customization , recommendation, #count of items in a category, discount offering etc. I think after that we can dive deep into the category and items bought within them section. See for each category what items are the most popular across the board and then also see cross selling of categories. The above will give you very basic information metrics of your platform (like User quality & Popular inventory ) before you even dive into building hypothesis , generating creative ideas or experimentation. Once you talk about this ( as a data expert) then the conversation can be carried to bigger ideas.

[@juliana1986j]

Please, make more videos like this one. Amazing insights! Txs

[@iqjayfeng]

Thanks! Stay tuned for today 😊

[@ivanrubnenkov919]

the guy is nailing while in the flow. very nice

[@rakeshpanthi3047]

insightful video for prospective data scientist....keep going...

[@iqjayfeng]

Thank you!

[@mrpam4672]

Nice video. Make more of these.

[@iqjayfeng]

Thank you. Stay tuned! 😃

[@NoahM.Angell-sd4ez]

the edits are 🔥

[@iqjayfeng]

Thanks!

[@mahi_sz]

Awesome 😮

[@iqjayfeng]

Thank you! Cheers!

[@factsdose6643]

Informative🙌

[@iqjayfeng]

Thanks 🙂

[@simon0295]

Nice interview! What are the best states for BI devrloper/analyst job?

[@TekKskakwmkwm111]

Or, of course, you could simply employ the AVG window function.

[@iqjayfeng]

Want to get a free coaching session with Chinmaya or our other expert coaches? Fill out this link airtable.com/appOP0epvU4xqjr6s/shrdQrwKK7xxGLm6l

[@soumyajitganguly2593]

Its just join and group by.. how is this hard?

[@SAURABHKUMAR-uk5gg]

exactly, I don't know why do people hype it up so much. Also, he could have just used avg function in the outer query

[@MonaLove143]

😆