?EY SQL Question Data Analyst Interview?

Question:
You work for an e-commerce company and you need to analyze customer purchasing behavior.
You are tasked with creating a table to store customer orders and generating a report that shows the top 5 customers with the highest total order amounts. The report should include the customer's name and the corresponding total order amount.

CREATE TABLE CustomerOrders (
OrderID INT PRIMARY KEY,
CustomerName VARCHAR(100),
OrderAmount DECIMAL(10, 2)
);

INSERT INTO CustomerOrders (OrderID, CustomerName, OrderAmount)
VALUES
(1, 'John Doe', 500.00),
(2, 'Jane Smith', 800.00),
(3, 'Michael Johnson', 1200.00),
(4, 'Emily Davis', 1500.00),
(5, 'David Wilson', 950.00),
(6, 'Sarah Brown', 2000.00),
(7, 'James Miller', 1800.00),
(8, 'Olivia Taylor', 600.00),
(9, 'Ethan Clark', 1400.00),
(10, 'Ava Lee', 1700.00);

Join us on Linkedin : www.linkedin.com/in/divyanka-gurap-a4736a268

Welcome to our channel, where we dive deep into the world of SQL and conquer real-life scenario-based questions! In this video, I will share some challenging SQL scenarios of interviews you may encounter in your career as a data professional.
Throughout the video, I will walk you through step-by-step solutions, explaining each query and its logic along the way. You'll understand how to approach different scenarios and leverage SQL's power to derive meaningful insights from data. Throughout the video, I will walk you through step-by-step solutions, explaining each query and its logic along the way. You'll understand how to approach different scenarios and leverage SQL's power to derive meaningful insights from data.