mahir_data
easyRHB Bank · basics

Show 'Unassigned' for branches without a manager

Some newly opened branches don't have a manager on file yet. Return name and manager for every branch, but display 'Unassigned' instead of a blank value when there's no manager.

Schema

branches
idINT
nameTEXT
managerTEXT

Example input

branches