| customer | profile | status | date    |

| 1        | 1       | DONE   | mmddyy  |

| 1        | 1       | DONE   | mmddyy  |

select customer, profile, status, max(date)
from tbl
group by profile, customer,status, date, column-k
having count(profile)>0 and status='DONE';