For example, assume that you want to divide your customers into high-value (more than $500), medium-value ($250-$500), and low-value (under $250) segments based on their purchase history over the last year. The PurchaseHistory field in your customer database stores the total dollar amount of each customer's purchases. Use a separate query to create each segment, selecting records with values in the
PurchaseHistory field that meet the criteria of the segment.