#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
En esta página del sitio puede ver el video en línea #SQL de Duración hora minuto segunda en buena calidad , que subió el usuario The Code Samples 15 septiembre 2024, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 196 veces y le gustó 11 a los espectadores. Disfruta viendo!
