LeetCode SQL Medium

Currently Playing: Leetcode MEDIUM 2292 - Products with 3 or More Orders in 2 Consecutive Years - Explained by EDS

Question: https://leetcode.com/problems/products-with-three-or-more-orders-in-two-consecutive-years/description/ SQL Schema: Create table If Not Exists Orders (order_id int, product_id int, quantity int, purchase_date date) Truncate table Orders insert into Orders (order_id, product_id, quantity, purchase_date) values ('1', '1', '7', '2020-03-16') insert into Orders (order_id, product_id, quantity, purchase_date) values ('2', '1', '4', '2020-12-02') insert into Orders (order_id, product_id, quantity, purchase_date) values ('3', '1', '7', '2020-05-10') insert into Orders (order_id, product_id, quantity, purchase_date) values ('4', '1', '6', '2021-12-23') insert into Orders (order_id, product_id, quantity, purchase_date) values ('5', '1', '5', '2021-05-21') insert into Orders (order_id, product_id, quantity, purchase_date) values ('6', '1', '6', '2021-10-11') insert into Orders (order_id, product_id, quantity, purchase_date) values ('7', '2', '6', '2022-10-11') Pandas Schema: data = [[1, 1, 7, '2020-03-16'], [2, 1, 4, '2020-12-02'], [3, 1, 7, '2020-05-10'], [4, 1, 6, '2021-12-23'], [5, 1, 5, '2021-05-21'], [6, 1, 6, '2021-10-11'], [7, 2, 6, '2022-10-11']] orders = pd.DataFrame(data, columns=['order_id', 'product_id', 'quantity', 'purchase_date']).astype({'order_id':'Int64', 'product_id':'Int64', 'quantity':'Int64', 'purchase_date':'datetime64[ns]'}) #datascience #mysqltutorials #leetcodesolutions