Leetcode MEDIUM 2020 - Accounts That Did Not Stream - SQL Explained by Everyday Data Science

Question: https://leetcode.com/problems/number-of-accounts-that-did-not-stream/description/

SQL Schema:
Create table If Not Exists Subscriptions (account_id int, start_date date, end_date date)
Create table If Not Exists Streams (session_id int, account_id int, stream_date date)
Truncate table Subscriptions
insert into Subscriptions (account_id, start_date, end_date) values ('9', '2020-02-18', '2021-10-30')
insert into Subscriptions (account_id, start_date, end_date) values ('3', '2021-09-21', '2021-11-13')
insert into Subscriptions (account_id, start_date, end_date) values ('11', '2020-02-28', '2020-08-18')
insert into Subscriptions (account_id, start_date, end_date) values ('13', '2021-04-20', '2021-09-22')
insert into Subscriptions (account_id, start_date, end_date) values ('4', '2020-10-26', '2021-05-08')
insert into Subscriptions (account_id, start_date, end_date) values ('5', '2020-09-11', '2021-01-17')
Truncate table Streams
insert into Streams (session_id, account_id, stream_date) values ('14', '9', '2020-05-16')
insert into Streams (session_id, account_id, stream_date) values ('16', '3', '2021-10-27')
insert into Streams (session_id, account_id, stream_date) values ('18', '11', '2020-04-29')
insert into Streams (session_id, account_id, stream_date) values ('17', '13', '2021-08-08')
insert into Streams (session_id, account_id, stream_date) values ('19', '4', '2020-12-31')
insert into Streams (session_id, account_id, stream_date) values ('13', '5', '2021-01-05')

Pandas Schema:
data = [[9, '2020-02-18', '2021-10-30'], [3, '2021-09-21', '2021-11-13'], [11, '2020-02-28', '2020-08-18'], [13, '2021-04-20', '2021-09-22'], [4, '2020-10-26', '2021-05-08'], [5, '2020-09-11', '2021-01-17']]
subscriptions = pd.DataFrame(data, columns=['account_id', 'start_date', 'end_date']).astype({'account_id':'Int64', 'start_date':'datetime64[ns]', 'end_date':'datetime64[ns]'})
data = [[14, 9, '2020-05-16'], [16, 3, '2021-10-27'], [18, 11, '2020-04-29'], [17, 13, '2021-08-08'], [19, 4, '2020-12-31'], [13, 5, '2021-01-05']]
streams = pd.DataFrame(data, columns=['session_id', 'account_id', 'stream_date']).astype({'session_id':'Int64', 'account_id':'Int64', 'stream_date':'datetime64[ns]'})

#leetcodesolutions #datascience #sql

Видео Leetcode MEDIUM 2020 - Accounts That Did Not Stream - SQL Explained by Everyday Data Science канала Everyday Data Science

Комментарии отсутствуют

Информация о видео

12 сентября 2024 г. 20:00:46

00:06:09

Everyday Data Science

Теги

Правообладателям

Жалоба на материал Недопустимый материал Нарушение авторских прав

Комментарии

Другие видео канала

Leetcode MEDIUM 2020 - Accounts That Did Not Stream - SQL Explained by Everyday Data Science

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 2995 - Viewers Turned Streamers - ROW_NUMBER() Ranking in SQL | Everyday Data Science

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