We will create time periods using DATEPART and FORMAT so that we can find the top 2 busiest times per week which will require a RANK function. You will also use a subquery and CTE in this SQL code.
#sql
#sqlinterview
#datascience
#dataanalyst
Learn and Practide SQL coding online at DataCamp, check out my affiliate link:
https://datacamp.pxf.io/KjO5ba
Watch video Amazon SQL Interview Questions | Top 2 Busiest Times | DATEPART online without registration, duration hours minute second in high quality. This video was added by user Absent Data 17 March 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 8,463 once and liked it 520 people.