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:






Comments

Post a Comment