How much in total does customer with first name as Carole and last name as Bernhard paid?
CREATE TABLE Customer_Payments (
    amount_payment INTEGER,
    customer_id VARCHAR
)

CREATE TABLE Customers (
    customer_id VARCHAR,
    first_name VARCHAR,
    last_name VARCHAR
)
SELECT SUM(T1.amount_payment) FROM Customer_Payments AS T1 JOIN Customers AS T2 ON T1.customer_id = T2.customer_id WHERE T2.first_name = "Carole" AND T2.last_name = "Bernhard"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How much in total does customer with first name as Carole and last name as Bernhard paid? ### Input: CREATE TABLE Customer_Payments (
    amount_payment INTEGER,
    customer_id VARCHAR
)

CREATE TABLE Customers (
    customer_id VARCHAR,
    first_name VARCHAR,
    last_name VARCHAR
) ### Response: SELECT SUM(T1.amount_payment) FROM Customer_Payments AS T1 JOIN Customers AS T2 ON T1.customer_id = T2.customer_id WHERE T2.first_name = "Carole" AND T2.last_name = "Bernhard"