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
| id | INT |
| name | TEXT |
| manager | TEXT |
Basic
The example input, expected output, and walkthrough for this question unlock with a Basic plan.
Basic
The reference solution and walkthrough for this question unlock with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime