By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 7 Duplicates: 0 Warnings: 0
Records: 4 Duplicates: 0 Warnings: 0
| CONCAT(GROUP_CONCAT(b.venueName ORDER BY level DESC SEPARATOR '-->') ,'-->',a.venueName) |
|---|
| Big Room-->Room Daisy |
| Big Room-->Room Rose |
| Big Room-->Room Rose-->Split 1 |
| Hall-->Meeting Room WP |