mahir_data
mediumDBS Bank · basics

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
nameTEXT
branch_customers
nameTEXT

Example input

online_customers
branch_customers