Solving Amazon Interview Question | Find the highest daily total order cost | Online Session

#AmazonInterivewQuestion #SQL #CleverStudies

In this video, we have resolved the below Amazon interview question:

Highest Cost Orders:
Find the customer with the highest daily total order cost between 2019-02-01 to 2019-05-01. If customer had more than one order on a certain day, sum the order costs on daily basis. Output their first name, total cost of their items, and the date.
For simplicity, you can assume that every first name in the dataset is unique. All other details are available in this video.

To join 'Clever Studies' whatsApp group And Free online sessions , pls click on the below invite link (subscribers only).
https://chat.whatsapp.com/C70cGzAEKC1LnSw60U9FVO
--------------------------------------------------
Gdrive Access Request for free material (subscribers only):
https://drive.google.com/drive/folders/1RGg05759zFAspRaT-RQGu6dpVeroLN2t?usp=sharing
--------------------------------------------------
To attend Free Weekend Online Sessions (subscribers only) , Pls send request to : [email protected].
--------------------------------------------------
To request free mock interview (members only) , Pls send request along with the latest resume to : [email protected].
--------------------------------------------------
Realtime Interview playlist :
https://www.youtube.com/watch?v=LIqtZxoT8Wk&list=PLCLE6UVwCOi1FRysr-OA6UM_kl2Suoubn
--------------------------------------------------
Apache Spark playlist :
https://www.youtube.com/watch?v=dpT2kTl7IPw&list=PLCLE6UVwCOi3jZp6JP9Q9qIKqJ1sFuaLC
--------------------------------------------------
PySpark playlist:
https://www.youtube.com/watch?v=_wkIl-WWbTM&list=PLCLE6UVwCOi0J0SrU2pNdGpACEQh4kqbC
--------------------------------------------------
Apache Hadoop playlist:
https://www.youtube.com/playlist?list=PLCLE6UVwCOi3kg3nCtaJgjfEcR8MJdndi
--------------------------------------------------
Bigdata playlist:
https://www.youtube.com/playlist?list=PLCLE6UVwCOi2uUGY-qeGTFSK5WWU-QEEw
--------------------------------------------------
Scala Playlist:
https://www.youtube.com/playlist?list=PLCLE6UVwCOi1DsZIULI7pRuelN6SaSoGd
--------------------------------------------------
SQL Playlist:
https://www.youtube.com/playlist?list=PLCLE6UVwCOi1_4FSzJDv4Ac_mqQYvZRSU

Hello Viewers,

We ‘Clever Studies’ YouTube Channel formed by group of experienced software professionals to fill the gap in the industry by providing free content on software tutorials, mock interviews, study materials, resume writing techniques, interview tips, knowledge sharing by Real-time working professionals and many more to help the freshers, working professionals, software aspirants to get a job.

If you like our videos, please do subscribe and share within your friends circle.

Contact us : [email protected]

Thank you !