LeetCode SQL Medium

Currently Playing: Leetcode MEDIUM 2993 - Friday Purchases I - Solved by Everyday Data Science | DAYNAME(), WEEK()

Question: https://leetcode.com/problems/friday-purchases-i/description/ SQL Schema: Create Table if Not Exists Purchases( user_id int, purchase_date date, amount_spend int) Truncate table Purchases insert into Purchases (user_id, purchase_date, amount_spend) values ('11', '2023-11-07', '1126') insert into Purchases (user_id, purchase_date, amount_spend) values ('15', '2023-11-30', '7473') insert into Purchases (user_id, purchase_date, amount_spend) values ('17', '2023-11-14', '2414') insert into Purchases (user_id, purchase_date, amount_spend) values ('12', '2023-11-24', '9692') insert into Purchases (user_id, purchase_date, amount_spend) values ('8', '2023-11-03', '5117') insert into Purchases (user_id, purchase_date, amount_spend) values ('1', '2023-11-16', '5241') insert into Purchases (user_id, purchase_date, amount_spend) values ('10', '2023-11-12', '8266') insert into Purchases (user_id, purchase_date, amount_spend) values ('13', '2023-11-24', '12000') Pandas Schema: data = [[11, '2023-11-07', 1126], [15, '2023-11-30', 7473], [17, '2023-11-14', 2414], [12, '2023-11-24', 9692], [8, '2023-11-03', 5117], [1, '2023-11-16', 5241], [10, '2023-11-12', 8266], [13, '2023-11-24', 12000]] purchases = pd.DataFrame(data, columns=['user_id', 'purchase_date', 'amount_spend']).astype({'user_id':'Int64', 'purchase_date':'datetime64[ns]', 'amount_spend':'Int64'}) #leetcodesolutions #leetcode #datascience