Problem Statement

Problem Description You are auditing an online store's order history. Write an SQL query that returns the names of every customer based in New York who has placed at least one order whose total cost exceeds $100 . For any single order, the total cost is computed as: Total cost = Price + Shipping . Schema Orders Table Column Name Type Description ProductId INT ID of the product ordered. CustomerId INT ID of the customer who made the order. Price INT The price of the product. Shipping INT The shipping cost for the order. Products Table Column Name Type Description ProductId INT ID of the product. Weight INT Weight of the product. CustomerId INT ID of the customer associated with the product. Customers Table Column Name Type Description CustomerId INT ID of the customer. CustomerName VARCHAR Name of the customer. City VARCHAR City where the customer resides. Required Output Return the distinct matching customer names as a single column called Customer . Row order in the result set is not