SQL Interview question | Find the most common activity done by each user in social media site
In this video we will solve 2 use cases
--customer behaviour analysis for one of a social media platform
-- QUESTION 1 : calcuate the most common action taken by all the people (most liked feature by the users)
-- QUESTION 2 : identify the most common action ( favourite action) taken by each user
-- if there is a tie between some actions for the top position then print all
-- of them with comma as a separator
Code link : https://github.com/bedwalsanjay/youtu...