ลูกค้าชื่อ Carole และนามสกุล Bernhard จ่ายเงินทั้งหมดเท่าไร ไม่จำเป็นต้องใช้ทุกตาราง
How much in total does customer with first name as Carole and last name as Bernhard paid?It is not neccessary to use all the tables.
 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"