Question

We want to send all of our high-value customers a special VIP gift. We are defining high-value customers as those who have made at least 1 order with a total value (not including the discount) equal to $10,000 or more. We only want to consider orders made in the year 2016. Who would we send the gift to? (Show customer ID, name, the order, and the total order amount.)

Answer 1

Answer:

Customer ID HANAR

Customer Name Hanari Carnes

Order ID 10981

Total Amount 15810.00

Explanation:

Companies focus on Customer retention policies for high valued customers. The companies do not want to upset their high valued clients and lose a great part of their sales from these customers. In this question all the high valued customers are sent gifts by the company who has shop for $10,000 or more from the company this year. From the given list we have sorted the high valued customers based on this criteria.