Update customer credit score on address update

Update customer credit score on address update: - Given a table of customer data with name, address, credit score, and date of last address update columns, - write a trigger that will automatically update the customer's credit score whenever their address is updated. - Output will be the customer table with updated credit scores.

Problem

Given a table of data with customer information, write a trigger that will automatically update the customer's credit score whenever their address is updated.
Input:
Customer table with columns for name, address, credit score, and date of last address update.
Output:
Customer table with updated credit scores.

Solution

This solution is in SQL. Our A.I. can create solutions in multiple languages.
by sarastevens 
CREATE TRIGGER update_credit_score
AFTER UPDATE ON customer
FOR EACH ROW
BEGIN
  UPDATE customer
  SET credit_score = credit_score + 1
  WHERE customer.id = NEW.id;
END;

/*

The trigger above will update the credit score of the customer whenever their address is updated.

The trigger is optimal because it will only update the credit score of the customer whose address was updated.

*/
A.I. Evaluation of the Solution

The trigger above will update the credit score of the customer whenever their address is updated. This is a good solution that solves the problem. The trigger is optimal because it will only update the credit score of the customer whose address was updated.

Evaluated at: 2023-01-27 16:26:48