This playlist contains scenario based SQL problems. After solving these you should be able to ace any SQL interview. As and when I find a good problem, i will add it to this playlist.
Curated by: Ankit Bansal (96 videos)
Customer retention refers to the ability of a company or product to retain its customers over some specified period. High customer retention means customers of the product or business tend to return to, continue to buy or in some other way not defect to another product or business, or to non-use entirely. Company programs to retain customers: Zomato Pro , Cashbacks, Reward Programs etc. Once these programs in place we need to build metrics to check if programs are working or not. That is where we will write SQL to drive customer retention count. If you preparing for SQL interviews for product based companies check this playlist : https://youtube.com/playlist?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb Here is the script to insert data : create table transactions( order_id int, cust_id int, order_date date, amount int ); delete from transactions; insert into transactions values (1,1,'2020-01-15',150) ,(2,1,'2020-02-10',150) ,(3,2,'2020-01-16',150) ,(4,2,'2020-02-25',150) ,(5,3,'2020-01-10',150) ,(6,3,'2020-02-20',150) ,(7,4,'2020-01-20',150) ,(8,5,'2020-02-20',150) ; #sql #interview #customer #retention