META | SQL Interview | Peak Period | CONCAT and Subquery
In the SQL interview question for data analysts given by META. You will use SQL code to find the peak period for online activity. You will use the CONCAT and DATEPART Functions to find the peak period by segmenting the start and end timestamps by the hour. Next, you will convert your findings into a subquery to aggregate the users.
#sqlinterview
#dataanalysis
#sql
Learn and Practide SQL coding online at DataCamp, check out my affiliate link:
https://datacamp.pxf.io/KjO5ba
