#SQL
#SQL Leetcode SQL 50 #22: 550:
Write a solution to report the fraction of players that logged in again on the day after the day they first logged in, rounded to 2 decimal places. In other words, you need to count the number of players that logged in for at least two consecutive days starting from their first login date, then divide that number by the total number of players.
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 Activity table
CREATE TABLE Activity (
player_id INT,
device_id INT,
event_date DATE,
games_played INT
);
-- Insert data into the Activity table (add more rows to it)
INSERT INTO Activity (player_id, device_id, event_date, games_played) VALUES
(1, 2, '2016-03-01', 5),
(1, 2, '2016-03-02', 6);
#datascience #coding #programming #mssql #databasemanagement #leetcode #leetcode550 #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
On this page of the site you can watch the video online #SQL with a duration of hours minute second in good quality, which was uploaded by the user The Code Samples 15 September 2024, share the link with friends and acquaintances, this video has already been watched 196 times on youtube and it was liked by 11 viewers. Enjoy your viewing!
