#SQL
#SQL Leetcode SQL 50 #24: 1141:
Write a solution to find the daily active user count for a period of 30 days ending 2019-07-27. A user was active on someday if they made at least one activity on that day.
We will be solving all the questions from LeetCode SQL 50 one by one. These questions range from easy to hard.
**SQL scripts you can use to create and populate the table:
-- Create the table:
CREATE TABLE Activity (
user_id INT,
session_id INT,
activity_date DATE,
activity_type VARCHAR(50)
);
-- Insert data into the table (add more rows to it):
INSERT INTO Activity (user_id, session_id, activity_date, activity_type)
VALUES (1, 1, '2019-07-20', 'open_session');
#datascience #coding #programming #mssql #databasemanagement #leetcode #leetcode1141 #leetcodesolution
👉SQL Tutorials Playlist:
• SQL Tutorials
👉SQL Shorts Playlist:
• SQL Shorts
👉Python Shorts Playlist:
• Playlist
👉Python Tutorials Playlist:
• Python Tutorials
👉Excel Shorts Playlist:
• Excel Shorts
