Amazon & EY SQL Interview Question | Advanced SQL Logic | (Real Interview Problem) скачать в хорошем качестве

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);