Write a query that returns the number of unique users per client per month

  Рет қаралды 72

InsightsLift

InsightsLift

Күн бұрын

Пікірлер: 5
@rajatjain001
@rajatjain001 11 сағат бұрын
Great info given
@vandanapatil8182
@vandanapatil8182 7 сағат бұрын
This type of explanation we need in all upcoming videos Like first explain the question, Then highlights the key points through comment in the query editor , Then write a query in slowly manner with proper explanation of why we are using this Pls follow this type of approach in all video And cover more problems from this website 😊 solve many problems from easy and medium level because no one is solving this problem from this website 😊 You're the 1st one so make it superhit playlist ma'am
@InsightsLift
@InsightsLift 3 сағат бұрын
@@vandanapatil8182 for sure
@InsightsLift
@InsightsLift 3 сағат бұрын
@@vandanapatil8182 Thankyou so much
@saijaswanth3036
@saijaswanth3036 5 сағат бұрын
SELECT client_id , MONTH(time_id) , COUNT(DISTINCT(user_id)) FROM fact_events GROUP BY client_id , MONTH(time_id)
Vampire SUCKS Human Energy 🧛🏻‍♂️🪫 (ft. @StevenHe )
0:34
Alan Chikin Chow
Рет қаралды 138 МЛН