By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | region | MAX(CASE WHEN status = 'y' THEN CONCAT_WS('-',val1,val2,val3) END) | MAX(CASE WHEN status = 'x' THEN CONCAT_WS('-',val1,val2,val3) END) |
|---|---|---|---|
| 1 | aa | 12-14-15 | 10-11-13 |
| 2 | bb |