Company: Tiger Analytics
Difficulty: medium
Problem Description Write an SQL query to retrieve the names of customers who live in New York and have ordered at least one product with a total cost of more than $100 . The total cost of an order is defined 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 a list of unique customer names meeting the criteria. The output should contain a single column named Customer . The order of the rows in the result set does not m