I have a table like this:
I have this postgres table.
date | sender_type | content |
---|---|---|
1 | PATIENT | A |
2 | PATIENT | B |
3 | USER | C |
4 | PATIENT | D |
5 | PATIENT | E |
6 | PATIENT | F |
7 | USER | G |
8 | USER | H |
I want an output like this
sender_type | content |
---|---|
PATIENT | A,B |
USER | C |
PATIENT | D,E,F |
USER | G,H |