select max(total), ; member_ref ; from ( ; select sum(amount) as Total, ; member_ref, ; description ; from payments ; where description like '%Test%' ; group by member_ref, description ; ) X ; group by 2