Highest_purchase_amount = groupby(CID, maxof, Purch_Amt)
ModelX_score = groupby(CID, maxof, if(Model = 'X', 1, 0), Score)
Bad_ModelX_score = if(Model = 'X', Score, NULL)