Filter date/month satisfy complex condition

Hi I have a table like this:  Date Customer Amount 15-Mar C 200 1-Apr A 100 26-May B 200 18-Jun C 300 13-Jun A 100   My problemn is, for each Customer, i need to ...