- Популярные видео
- Авто
- Видео-блоги
- ДТП, аварии
- Для маленьких
- Еда, напитки
- Животные
- Закон и право
- Знаменитости
- Игры
- Искусство
- Комедии
- Красота, мода
- Кулинария, рецепты
- Люди
- Мото
- Музыка
- Мультфильмы
- Наука, технологии
- Новости
- Образование
- Политика
- Праздники
- Приколы
- Природа
- Происшествия
- Путешествия
- Развлечения
- Ржач
- Семья
- Сериалы
- Спорт
- Стиль жизни
- ТВ передачи
- Танцы
- Технологии
- Товары
- Ужасы
- Фильмы
- Шоу-бизнес
- Юмор
Leetcode HARD 2995 - Viewers Turned Streamers - ROW_NUMBER() Ranking in SQL | Everyday Data Science
Question: https://leetcode.com/problems/viewers-turned-streamers/
SQL Schema:
Create table If Not Exists Sessions (user_id int, session_start datetime, session_end datetime, session_id int, session_type ENUM('Viewer','Streamer'))
Truncate table Sessions
insert into Sessions (user_id, session_start, session_end, session_id, session_type) values ('101', '2023-11-06 13:53:42', '2023-11-06 14:05:42', '375', 'Viewer')
insert into Sessions (user_id, session_start, session_end, session_id, session_type) values ('101', '2023-11-22 16:45:21', '2023-11-22 20:39:21', '594', 'Streamer')
insert into Sessions (user_id, session_start, session_end, session_id, session_type) values ('102', '2023-11-16 13:23:09', '2023-11-16 16:10:09', '777', 'Streamer')
insert into Sessions (user_id, session_start, session_end, session_id, session_type) values ('102', '2023-11-17 13:23:09', '2023-11-17 16:10:09', '778', 'Streamer')
insert into Sessions (user_id, session_start, session_end, session_id, session_type) values ('101', '2023-11-20 07:16:06', '2023-11-20 08:33:06', '315', 'Streamer')
insert into Sessions (user_id, session_start, session_end, session_id, session_type) values ('104', '2023-11-27 03:10:49', '2023-11-27 03:30:49', '797', 'Viewer')
insert into Sessions (user_id, session_start, session_end, session_id, session_type) values ('103', '2023-11-27 03:10:49', '2023-11-27 03:30:49', '798', 'Streamer')
Pandas Schema:
data = [[101, '2023-11-06 13:53:42', '2023-11-06 14:05:42', 375, 'Viewer'], [101, '2023-11-22 16:45:21', '2023-11-22 20:39:21', 594, 'Streamer'], [102, '2023-11-16 13:23:09', '2023-11-16 16:10:09', 777, 'Streamer'], [102, '2023-11-17 13:23:09', '2023-11-17 16:10:09', 778, 'Streamer'], [101, '2023-11-20 07:16:06', '2023-11-20 08:33:06', 315, 'Streamer'], [104, '2023-11-27 03:10:49', '2023-11-27 03:30:49', 797, 'Viewer'], [103, '2023-11-27 03:10:49', '2023-11-27 03:30:49', 798, 'Streamer']]
sessions = pd.DataFrame(data, columns=['user_id', 'session_start', 'session_end', 'session_id', 'session_type']).astype({'user_id':'Int64', 'session_start':'datetime64[ns]', 'session_end':'datetime64[ns]', 'session_id':'Int64', 'session_type':'object'})
#leetcode #datascience #tutorial
Видео Leetcode HARD 2995 - Viewers Turned Streamers - ROW_NUMBER() Ranking in SQL | Everyday Data Science канала Everyday Data Science
SQL Schema:
Create table If Not Exists Sessions (user_id int, session_start datetime, session_end datetime, session_id int, session_type ENUM('Viewer','Streamer'))
Truncate table Sessions
insert into Sessions (user_id, session_start, session_end, session_id, session_type) values ('101', '2023-11-06 13:53:42', '2023-11-06 14:05:42', '375', 'Viewer')
insert into Sessions (user_id, session_start, session_end, session_id, session_type) values ('101', '2023-11-22 16:45:21', '2023-11-22 20:39:21', '594', 'Streamer')
insert into Sessions (user_id, session_start, session_end, session_id, session_type) values ('102', '2023-11-16 13:23:09', '2023-11-16 16:10:09', '777', 'Streamer')
insert into Sessions (user_id, session_start, session_end, session_id, session_type) values ('102', '2023-11-17 13:23:09', '2023-11-17 16:10:09', '778', 'Streamer')
insert into Sessions (user_id, session_start, session_end, session_id, session_type) values ('101', '2023-11-20 07:16:06', '2023-11-20 08:33:06', '315', 'Streamer')
insert into Sessions (user_id, session_start, session_end, session_id, session_type) values ('104', '2023-11-27 03:10:49', '2023-11-27 03:30:49', '797', 'Viewer')
insert into Sessions (user_id, session_start, session_end, session_id, session_type) values ('103', '2023-11-27 03:10:49', '2023-11-27 03:30:49', '798', 'Streamer')
Pandas Schema:
data = [[101, '2023-11-06 13:53:42', '2023-11-06 14:05:42', 375, 'Viewer'], [101, '2023-11-22 16:45:21', '2023-11-22 20:39:21', 594, 'Streamer'], [102, '2023-11-16 13:23:09', '2023-11-16 16:10:09', 777, 'Streamer'], [102, '2023-11-17 13:23:09', '2023-11-17 16:10:09', 778, 'Streamer'], [101, '2023-11-20 07:16:06', '2023-11-20 08:33:06', 315, 'Streamer'], [104, '2023-11-27 03:10:49', '2023-11-27 03:30:49', 797, 'Viewer'], [103, '2023-11-27 03:10:49', '2023-11-27 03:30:49', 798, 'Streamer']]
sessions = pd.DataFrame(data, columns=['user_id', 'session_start', 'session_end', 'session_id', 'session_type']).astype({'user_id':'Int64', 'session_start':'datetime64[ns]', 'session_end':'datetime64[ns]', 'session_id':'Int64', 'session_type':'object'})
#leetcode #datascience #tutorial
Видео Leetcode HARD 2995 - Viewers Turned Streamers - ROW_NUMBER() Ranking in SQL | Everyday Data Science канала Everyday Data Science
data science data analysis data science interview prep LeetCode solutions everyday data science data science portfolio projects data structures and algorithms sql window function data enegineering sql tutorial solved answers learn sql fast how to learn sql practice sql questions step by step solution data analytics best sql video window function leetcode 2995 learn to earn sql interview us elections uber leetcode hard viewers turned streamers
Комментарии отсутствуют
Информация о видео
12 ноября 2024 г. 8:00:27
00:06:32
Другие видео канала
Crush Your SQL Interview: 50 Advanced Questions That Will Set You Apart -Leetcode 511 | Data Science
Leetcode MEDIUM 3657 - GROUP BY & Common Table Expressions in SQL - Find Loyal Customers | EDS
Leetcode MEDIUM 3308 - Find Top Performing Driver - ROW_NUMBER() in SQL | Everyday Data Science
Learn SQL Important Interview Concepts with 50 Hands-On Challenges! - Leetcode 1907 | Data Science
Leetcode 2990 - Loan Types - Solved by Everyday Data Science | GROUPBY, HAVING, COUNT DISTINCT
Secure Your Dream Salary with 50 Advanced SQL Interview Questions! - Data Science | Leetcode 1587
Leetcode MEDIUM 3808 - 3 Window Functions in 1 SQL Query - Find Emotionally Consistent Users | EDS
Mastering GOOGLE & AMAZON Data Science Interview - Your Ultimate Solution!
How to check for a range while using .QUERY() in DataFrames - Amazon Interview | Python Data Science
Leetcode MEDIUM 3055 - Top Percentile Fraud PERCENT_RANK() SQL - Explained by Everyday Data Science
LeetCode Medium 1355 IBM Interview SQL Question with Detailed Explanation
SQL Elite: Prep for High Paying Tech Interviews with Advanced Qs - Data Science | Leetcode 1549
Leetcode 2987 - Find Expensive Cities - Solved by Everyday Data Science | WINDOW Functions
SQL Skills That Sell: Prep for High-Paying Job Interviews! - Data Science | Leetcode 1795
Stratascratch 9673 - SQL & Python Solution - Find Unique IATA Codes | Everyday Data Science
Leetcode HARD 1645 - RECURSIVE CTE SQL Explained - Hopper Company Queries 2 | Everyday Data Science
Leetcode HARD 2118 - Build The Equation CONCAT vs GROUP_CONCAT : Explained by Everyday Data Science
Next-Level SQL: Interview Prep for Aspirants Targeting High Paid Jobs - Data Science | Leetcode 1511
Leetcode HARD 1336 - RECURSIVE CTE SQL Explained - Transactions Per Visit | Everyday Data Science
Leetcode MEDIUM 1132 - Reported Posts II DISTINCT ROUND AVERAGE - Explained by Everyday Data Science
