Sample table:
date | name | record
7/27/16 | john | H
7/27/16 | john | P
7/28/16 | john | P
7/28/16 | john | L
Results:
date | name | record
7/27/16 | john | H,P
7/27/16 | john | H,L
Query:
SELECT
date, name, record
FROM
TABLE
GROUP BY
date, name, record(not sure how to do this part)