Problem: In SQL, create a function (or stored procedure) that calculates the "consolidated customer ID". As both banks have an integer customer ID, but they may have the same ID for different customers; and all existing customer IDs are under 1 million, for both banks, the new ID will be 10 million (10000000) plus the customer ID, if the customer comes from OldBank; and 20 million (20000000) plus the customer ID, if the customer comes from NewBank.
ARTS & HUMANITIES
COMMUNICATIONS
MARKETING