Every customer who has banked online or in a branch
DBS tracks online-banking and branch-visit customers in separate tables. Ops wants one combined, de-duplicated list of every customer who has used either channel.
Return name: each customer should appear once, even if they've used both channels.
Schema
▸online_customers
| name | TEXT |
▸branch_customers
| name | 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