Amazon & EY SQL Interview Question | Advanced SQL Logic | (Real Interview Problem)

In this video, we solve a real-world SQL interview question that is commonly asked in Amazon, EY, and Gemini-level data interviews.

You are given:

A players table

A Grand Slam results table with Wimbledon, French Open, US Open, and Australian Open winners stored as columns

🎯 Task:
Calculate the total number of Grand Slams won by each player using optimized SQL logic.

This problem tests:

Column-to-row transformation (UNPIVOT / UNION ALL)

Joins and aggregation

Interview-ready SQL thinking

Performance-optimized query design

💡 Perfect for:

SQL Interview Preparation

Data Analyst / Data Engineer roles

Amazon, EY, Big Tech SQL rounds

If you want more real interview-style SQL questions, subscribe and comment below 🚀
.
.
.
#SQLInterview
#AmazonSQL
#DataAnalyst
#SQLQueries
#InterviewPreparation
**********************************************************
CREATE TABLE #players (
player_id INT PRIMARY KEY,
player_name VARCHAR(50)
);

INSERT INTO #players (player_id, player_name)
VALUES
(1, 'Nadal'),
(2, 'Federer'),
(3, 'Novak');
CREATE TABLE #grand_slam_results (
year INT PRIMARY KEY,
Wimbledon INT,
Fr_open INT,
US_open INT,
Au_open INT
);

INSERT INTO #grand_slam_results (year, Wimbledon, Fr_open, US_open, Au_open)
VALUES
(2024, 2, 1, 1, 2),
(2025, 3, 1, 3, 2),
(2026, 3, 1, 1, 3);

Видео Amazon & EY SQL Interview Question | Advanced SQL Logic | (Real Interview Problem) канала The Data -Tech Club