By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| bay | alpha_key |
|---|---|
| ZZZ-AA1 | ZZZ-AA |
| ZZZ-AA2 | ZZZ-AA |
| ZZZ-AA3 | ZZZ-AA |
| ZZZ-AA11 | ZZZ-AA |
| ZZZ-AA12 | ZZZ-AA |
| ZZZ-AAA1 | ZZZ-AAA |
| ZZZ-AB1 | ZZZ-AB |
| ZZZ-AB2 | ZZZ-AB |
| ZZZ-BB1 | ZZZ-BB |
| ZZZ-BB12 | ZZZ-BB |
| ZZZ-CA1 | ZZZ-CA |