如何在mysql中使用状态来表示地址

I'm trying to concatenate all address with state, suppose i've row with same state and different address so i want to run Query that will bring something asI'm trying to concatenate all address with stat