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)
Product recommendation. Just the basic type (“customers who bought this also bought…”). That, in its simplest form, is an outcome of basket analysis. In this video we will learn how to find products which are most frequently bought together using simple SQL. Based on the history ecommerce website can recommend products to new user. Playlist for complex SQL questions: https://www.youtube.com/playlist?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb Here is the ready script to practice it: create table orders ( order_id int, customer_id int, product_id int, ); insert into orders VALUES (1, 1, 1), (1, 1, 2), (1, 1, 3), (2, 2, 1), (2, 2, 2), (2, 2, 4), (3, 1, 5); create table products ( id int, name varchar(10) ); insert into products VALUES (1, 'A'), (2, 'B'), (3, 'C'), (4, 'D'), (5, 'E');