#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
Watch video #SQL online without registration, duration hours minute second in high quality. This video was added by user The Code Samples 29 September 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 154 once and liked it 11 people.