1141. User Activity for the Past 30 Days I | Leetcode | Hindi

Описание: Problem link - https://leetcode.com/problems/user-ac...

Write a solution to find the daily active user count for a period of 30 days ending 2019-07-27 inclusively. A user was active on someday if they made at least one activity on that day.

Return the result table in any order.

The result format is in the following example.

SOLUTION -

select activity_date as day, count( DISTINCT user_id ) AS active_users
from Activity
where activity_date (PUT GREATER THAN SIGN HERE) DATE_SUB('2019-07-27', INTERVAL 30 DAY)
and
activity_date (PUT LESS THAN SIGN HERE) '2019-07-27'
group by activity_date

#leetcodesql #FAANG #SQLinterviewQuestions
#sql #sqlinterviewquestions #sqlinterviewquestionsandanswers #sqlquestions

Related keywords
sql interview questions
sql interview questions and answers
sql interview
sql questions and answers
top sql questions
sql interview questions for freshers
sql interview questions for beginners
sql interview questions for experienced
intermediate level sql interview questions
sql queries interview questions and answers
sql interview preparation
sql basic questions
sql questions
sql query
interview questions sq