SQL Interview Questions Part 67 | Year on Year Growth Rate SQL Problem 🔥🔥

SQL Interview Questions Part 67 | Year on Year Growth Rate SQL Problem 🔥🔥
Problem Statement :- There is a table called User_Transaction which contains information about XYZ company users transactions for different products.
Write a query to calculate the Year-on-Year growth rate for the total spend of each product
YoY growth = ((current period value - last period value) / last period value) x 100
-------------------------------------------------------------------------
𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
-------------------------------------------------------------------------
*Instagram :
/ itjunction4all
*Twitter:
/ sunilkr5672
-------------------------------------------------------------------------
Table and Insert SQL Script :
-------------------------------------------------------------------------
CREATE TABLE user_transaction (
transaction_id INTEGER PRIMARY KEY,
product_id INTEGER,
spend DECIMAL(10, 2),
transaction_date DATETIME
);
INSERT INTO user_transaction VALUES(1, 101, 50.00, CONVERT(datetime,'2021-01-15T00:00:00',126))
INSERT INTO user_transaction VALUES(2, 101, 75.00, CONVERT(datetime,'2022-02-20T00:00:00',126))
INSERT INTO user_transaction VALUES(3, 101, 100.00, CONVERT(datetime,'2023-03-10T00:00:00',126))
INSERT INTO user_transaction VALUES(4, 101, 200.00, CONVERT(datetime,'2023-01-12T00:00:00',126))
INSERT INTO user_transaction VALUES(5, 101, 150.00, CONVERT(datetime,'2024-01-10T00:00:00',126))
INSERT INTO user_transaction VALUES(6, 102, 200.00, CONVERT(datetime,'2022-02-25T00:00:00',126))
INSERT INTO user_transaction VALUES(7, 102, 250.00, CONVERT(datetime,'2023-05-30T00:00:00',126))
INSERT INTO user_transaction VALUES(8, 102, 300.00, CONVERT(datetime,'2024-02-14T00:00:00',126))
INSERT INTO user_transaction VALUES(9, 103, 350.00, CONVERT(datetime,'2022-06-18T00:00:00',126))
INSERT INTO user_transaction VALUES(10, 103, 300.00, CONVERT(datetime,'2023-08-20T00:00:00',126))
INSERT INTO user_transaction VALUES(11, 104, 450.00, CONVERT(datetime,'2022-09-25T00:00:00',126))
INSERT INTO user_transaction VALUES(12, 104, 500.00, CONVERT(datetime,'2022-10-30T00:00:00',126))
#SQL #trickysql #itjunction4all

[@bankimdas9517]

Thanks for this video sir

[@ItJunction4all]

You are welcome !

[@bankimdas9517]

@@ItJunction4all Sir how much sql one should to enter in data analytics field?

[@ItJunction4all]

You should have good command in SQL so that you can do better data analysis in Data Analytics field. Try to solve problems in my SQL playlist that is more than enough.

[@bankimdas9517]

@@ItJunction4all Thanks a lot sir for your suggestion. Thanks for sparing your time to reply me.. 🙏

[@ItJunction4all]

No Problem :)