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)
In this video we will discuss a very interesting SQL interview problem asked in Probo data analytics interview. take your SQL skills to SKY : https://www.namastesql.com/ script: create table polls ( user_id varchar(4), poll_id varchar(3), poll_option_id varchar(3), amount int, created_date date ) -- Insert sample data into the investments table INSERT INTO polls (user_id, poll_id, poll_option_id, amount, created_date) VALUES ('id1', 'p1', 'A', 200, '2021-12-01'), ('id2', 'p1', 'C', 250, '2021-12-01'), ('id3', 'p1', 'A', 200, '2021-12-01'), ('id4', 'p1', 'B', 500, '2021-12-01'), ('id5', 'p1', 'C', 50, '2021-12-01'), ('id6', 'p1', 'D', 500, '2021-12-01'), ('id7', 'p1', 'C', 200, '2021-12-01'), ('id8', 'p1', 'A', 100, '2021-12-01'), ('id9', 'p2', 'A', 300, '2023-01-10'), ('id10', 'p2', 'C', 400, '2023-01-11'), ('id11', 'p2', 'B', 250, '2023-01-12'), ('id12', 'p2', 'D', 600, '2023-01-13'), ('id13', 'p2', 'C', 150, '2023-01-14'), ('id14', 'p2', 'A', 100, '2023-01-15'), ('id15', 'p2', 'C', 200, '2023-01-16'); create table poll_answers ( poll_id varchar(3), correct_option_id varchar(3) ) -- Insert sample data into the poll_answers table INSERT INTO poll_answers (poll_id, correct_option_id) VALUES ('p1', 'C'),('p2', 'A'); Zero to hero(Advance) SQL Aggregation: https://youtu.be/5Ighj_2PGV0 Most Asked Join Based Interview Question: https://youtu.be/xR87ctOgpAE Solving 4 Trick SQL problems: https://youtu.be/Ck1gQrlS5pQ Data Analyst Spotify Case Study: https://youtu.be/-YdAIMjHZrM Top 10 SQL interview Questions: https://youtu.be/Iv9qBz-cyVA Interview Question based on FULL OUTER JOIN: https://youtu.be/KQfWd6V3IB8 Playlist to master SQL : https://youtube.com/playlist?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb Rank, Dense_Rank and Row_Number: https://youtu.be/xMWEVFC4FOk #sql #dataanalytics