You can perform a join between the

customer

and

credithistory

data set to get the desired output. However, a join creates duplicate data rows for all the customers in the data set. For example, if a customer with ID

101

has credit scores

687

,

630

, and

605

, a join creates three data rows for the credit scores of the customer.

Implement one of the following solutions to resolve this issue.