SQL

Customers who spent below the average

SELECT Customer_Id, TotalSpend_90Days, AverageSpend_90days

FROM Customer_Spend_90DaysVsAVG

WHERE TotalSpend_90Days <=  AverageSpend_90days

Leave a Reply

Your email address will not be published. Required fields are marked *