Indium SQL Interview Question | Medium-Level

In this video, we will solve a common SQL interview question asked at Indium Technologies — finding match combinations using self-join. Learn how to use self-joins effectively to compare rows within the same table and uncover meaningful pairings. Script: -- Create the table CREATE TABLE teams ( team_name VARCHAR(50) NOT NULL ); -- Insert team names INSERT INTO teams (team_name) VALUES ('CSK'), ('KKR'), ('GT'), ('DC'), ('LSG'); TIMESTAMP 00:00 Introduction 00:20 Problem Statement 02:09 Problem Solving Approach 04:26 Finding the expected output 08:36 Writing Final SQL Query SQL Series for Beginners:    • What is SQL? | Types of SQL Commands | SQL...   Solve more company-focused SQL Questions here -    • Uber SQL Assessment Solved | Pre-Screening...   Check out Educative.io to boost your portfolio and get interview ready with 700+ hands-on courses - https://www.educative.io/explore Get additional 10% off using this link - https://www.educative.io/unlimited?af... #sql #sqlinterview #dataanlysis #sqltutorial