Complex SQL Questions for Interview Preparation

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)

---

Currently Playing: SQL Question Asked in a FAANG Interview | Complex SQL 4

In this video we will discuss a question which was asked in one of the FAANG SQL interview. Do try yourself and let me know if you have a better solution.

---

Tracks in this Playlist

• Complex SQL Query 1 | Derive Points table for ICC tournament
• Complex SQL 2 | find new and repeat customers | SQL Interview Questions
• Complex SQL 3 | Scenario based Interviews Question for Product companies
• SQL Question Asked in a FAANG Interview | Complex SQL 4
• Pareto Principle (80/20 Rule) Implementation in SQL | SQL Interview Question
• Complex SQL 6 | Scenario based on join, group by and having clauses | SQL Interview Question
• Leetcode Hard Problem | Complex SQL 7 | Trips and Users
• Leetcode Hard problem 2| Tournament Winners | Complex SQL 8
• Leetcode Hard Problem 3 | Market Analysis 2 | Complex SQL 9
• An Awesome Tricky SQL Logic | Complex SQL 10
• Leetcode Hard Problem 4 | User Purchase Platform | Complex SQL 11
• Recursive CTE | Leetcode Hard SQL Problem 5 | Complex SQL 12
• Data Science SQL Interview Question | Recommendation System | Complex SQL 13
• Amazon Prime Subscription Rate SQL Logic | Amazon Music | Complex SQL 14
• Customer Retention and Churn Analysis (Part 1/2) | SQL Interview Question Product Based Companies
• Customer Retention and Churn Analysis (Part 2/2) | SQL Interview Question Product Based Companies
• Leetcode Hard SQL Problem - 6 | Second Most Recent Activity | SQL Window Analytical Functions
• Scenario Based SQL Question | Solving Using SCD Type 2 Concept | SQL Interview Question
• Data Analyst Spotify Case Study | SQL Interview Questions
• How to Write Advanced SQL Queries | Consecutive Empty Seats | SQL Interview Questions
• SQL Interview Question and Answers Using 3 Methods | Find Missing Quarter
• Deadly Combination of Group By and Having Clause in SQL | SQL Interview Questions and Answers
• Beauty of SQL RANK Function | SQL Interview Question and Answers | Covid Cases
• Google SQL Interview Question for Data Analyst Position
• Meesho HackerRank SQL Interview Question and Answer | Customer Budget
• Horizontal Sorting in SQL | Amazon Interview Question for BIE position
• Solving 4 Tricky SQL Problems
• Brilliant SQL Interview Question | Solve it without using CTE, Sub Query, Window functions
• Solving A Hard SQL Problem | SQL ON OFF Problem | Magic of SQL
• LeetCode Hard SQL problem | Students Reports By Geography | Pivot Ka Baap
• LeetCode Hard SQL Problem | Employee Median Salary Company Wise
• I Asked This SQL Interview Question in an Amazon Interview | Most Asked SQL Problem with a Twist
• Leetcode Hard SQL Problem | Human Traffic of Stadium
• Very Interesting SQL Interview Question Asked by Udaan | Power of Self Join | Data Analytics
• PharmEasy SQL Interview Question | Consecutive Seats in a Movie Theatre | Data Analytics
• Bosch Scenario Based SQL Interview Question | Solving Using 3 Methods | Data Analytics
• Cricket Analytics with SQL | Find Sachin's Milestone Matches | Advance SQL
• This SQL Problem I Could Not Answer in Deloitte Interview | Last Not Null Value | Data Analytics
• Leetcode-1412 Hard SQL Problem | Find the Quiet Students in All Exams | Data Analytics
• Walmart Labs SQL Interview Question for Senior Data Analyst Position | Data Analytics
• Microsoft SQL Interview Question for Data Engineer Position | Data Analytics
• Double Self Join in SQL | Amazon Interview Question | Excel Explanation Included | Data Analytics
• A Good SQL Problem Based on Bank Transactions Asked in Visa Interview
• Airbnb Tricky SQL Interview Problem #DataLemur
• SQL Pre-Screening Test For Data Engineer Position | Delta Records | Data Analytics
• Uber Very Interesting SQL Interview Problem | Solving Using 2 Methods | Data Analytics
• Tricky SQL Interview Problem Asked in Amazon
• Marketing Campaign Success SQL Advanced Problem | Step by Step Solution using CTEs
• Complex SQL Problem Asked in a Fintech Startup | SQL For Data Analytics
• Tricky SQL Challenge | SQL For Data Analytics
• Data Analyst Case Study by A Major Travel Company | SQL for Data Analytics
• Amazon Data Engineer SQL Interview Problem | Leetcode Hard SQL 2494 | Recursive CTE
• PayPal SQL Interview Problem (Level Hard) | Advanced SQL Problem
• PayPal Data Engineer SQL Interview Question (and a secret time saving trick)
• Uplers SQL Interview Problem (Senior Data Analyst) | Includes 4 Test Cases
• Solving a Advanced SQL Interview Problem | Advanced SQL Tutorial
• Solving a Namaste SQL Assignment Question | SQL For Analytics
• Solving a Leetcode DSA Problem with SQL | Advanced SQL for Analytics | Aam vs Mentos Life
• Freshworks Data Analyst SQL Interview Problem | SQL For Data Analytics
• SQL For Business Intelligence | YoY, QoQ, MTD, YTD, QTD etc. in a Single SQL
• Famous SQL Interview Question | First Name , Middle Name and Last Name of a Customer
• Tricky SQL Interview Question by a Product Based Company | Ludo King SQL Analytics
• Top 5 Advanced SQL Interview Questions and Answers | Frequently Asked SQL interview questions
• Swiggy Data Analyst SQL Interview Question and Answer
• 3 Solutions to a ITC Infotech SQL Interview Question
• Meesho SQL Interview Question for Data Analysts | SQL Non-Equi Join | Aam vs Mentos Zindagi
• 15 Days of Learning SQL | Advanced SQL for Data Analytics
• Fractal Analytics SQL Interview Question (Game of Thrones Database) | SQL for Data Engineer
• SQL Portfolio Project for Data Analysis | SQL Interview Questions and Answers
• SQL Interview Question Asked in Tredence Analytics
• American Express SQL Interview Question and Solution | Page Recommendation
• Acies Global SQL Interview Question | Employee Swipe in and Swipe out
• Solving an Amazon SQL Interview Question on Notepad
• Zepto Product Analyst SQL Interview Question
• Probo Very Interesting SQL Interview Question | Difficulty Level Hard | SQL For Data Analytics
• Regex Based SQL Interview Question | Postgres Regular Expressions | SQL for Analytics
• Top Data Analyst SQL Interview Question by A Startup
• IPL Data Analysis SQL Interview Questions | Analytics Engineering
• EPAM SQL Coding Test Interview Questions | Aam vs Mentos Life
• REAL SQL Interview Question by a FAANG Company | SQL Interview Questions and Answers
• SQL Project for Data Analytics (Level - Advanced)
• Can You Solve This Hard SQL Question😢😢 | Parent Child Hierarchy | Recursive CTE
• How to Write Long and Complex SQL Queries For Real Reports (Step-by-Step)
• Amazon Interview - 99% Fail This SQL Hierarchy Problem - Can You Solve It?
• Microsoft SQL Interview Question | Possible Flight Routes
• Solve 5 Tricky SQL Interview Questions in 1 Hour
• LinkedIn REAL SQL Interview Question | SQL For Data Analytics
• SQL Case Study : Naukri Resume Data Analysis | Data Analytics Project
• Blinkit Data Analyst SQL Assessment
• SQL Interview Question By A Startup | Normal vs Mentos Life 😎
• Football Tournament Rank Table | SQL For Data Analytics
• Last Minute SQL Interview Prep Kit: Complete Revision in 3 Hours
• 5 SQL Questions To Crack Senior Data Roles
• Most Asked Data Engineer SQL Interview Question | Rank and Dense_Rank Without Window Functions
• Crazy SQL Interview Problem for Senior Data Engineers | Cyclic Money Transactions
• Target SQL Interview Question | Strong Mutual Friends