Sunday, May 7, 2023

IntreviewQuestion||Ask by Amazon Shopify || Stratascratch

 

Highest Cost Orders Data Analyst Intreview #Highest Cost Orders Data Analyst IntreviewQuestion||Ask by Amazon Shopify || Stratascratch


Que-https://platform.stratascratch.com/coding/9915-highest-cost-orders?code_type=2


--Find the customer with the highest daily total order cost between 2019-02-01 to 2019-05-01. If the customer had more than one order on a certain day, sum the order costs on a daily basis.


--Output the customer's first name, the total cost of their items, and the date.


Check out the solution:

https://youtu.be/u1blDrpxPgY


Click here to download the script:






at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

"🚀 Delta Lake's Vectorized Delete: The Secret to 10x Faster Data Operations!"

"🚀 Delta Lake's Vectorized Delete: The Secret to 10x Faster Data Operations!" Big news for data engineers! Delta Lake 2.0+ in...