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 based on ludo king game. This was asked in a Gameberry Labs Interview for a product analyst position. Start your data analytics journey: https://www.namastesql.com/ Script: CREATE TABLE user_interactions ( user_id varchar(10), event varchar(15), event_date DATE, interaction_type varchar(15), game_id varchar(10), event_time TIME ); -- Insert the data INSERT INTO user_interactions VALUES ('abc', 'game_start', '2024-01-01', null, 'ab0000', '10:00:00'), ('def', 'game_start', '2024-01-01', null, 'ab0000', '10:00:00'), ('def', 'send_emoji', '2024-01-01', 'emoji1', 'ab0000', '10:03:20'), ('def', 'send_message', '2024-01-01', 'preloaded_quick', 'ab0000', '10:03:49'), ('abc', 'send_gift', '2024-01-01', 'gift1', 'ab0000', '10:04:40'), ('abc', 'game_end', '2024-01-01', NULL, 'ab0000', '10:10:00'), ('def', 'game_end', '2024-01-01', NULL, 'ab0000', '10:10:00'), ('abc', 'game_start', '2024-01-01', null, 'ab9999', '10:00:00'), ('def', 'game_start', '2024-01-01', null, 'ab9999', '10:00:00'), ('abc', 'send_message', '2024-01-01', 'custom_typed', 'ab9999', '10:02:43'), ('abc', 'send_gift', '2024-01-01', 'gift1', 'ab9999', '10:04:40'), ('abc', 'game_end', '2024-01-01', NULL, 'ab9999', '10:10:00'), ('def', 'game_end', '2024-01-01', NULL, 'ab9999', '10:10:00'), ('abc', 'game_start', '2024-01-01', null, 'ab1111', '10:00:00'), ('def', 'game_start', '2024-01-01', null, 'ab1111', '10:00:00'), ('abc', 'game_end', '2024-01-01', NULL, 'ab1111', '10:10:00'), ('def', 'game_end', '2024-01-01', NULL, 'ab1111', '10:10:00'), ('abc', 'game_start', '2024-01-01', null, 'ab1234', '10:00:00'), ('def', 'game_start', '2024-01-01', null, 'ab1234', '10:00:00'), ('abc', 'send_message', '2024-01-01', 'custom_typed', 'ab1234', '10:02:43'), ('def', 'send_emoji', '2024-01-01', 'emoji1', 'ab1234', '10:03:20'), ('def', 'send_message', '2024-01-01', 'preloaded_quick', 'ab1234', '10:03:49'), ('abc', 'send_gift', '2024-01-01', 'gift1', 'ab1234', '10:04:40'), ('abc', 'game_end', '2024-01-01', NULL, 'ab1234', '10:10:00'), ('def', 'game_end', '2024-01-01', NULL, 'ab1234', '10:10:00'); 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 #dataengineer