Task: Text to Code
Input (English): SQL: SELECT T1.hire_date FROM employees AS T1 JOIN customers AS T2 ON T1.id = T2.support_rep_id WHERE T2.last_name = "Lucas"
Feedback: Replace employees table with invoices , hire date with total of invoices , make sure customer's fullname equals Lucas Mancini .
Output (English): SELECT sum(T2.total) FROM customers AS T1 JOIN invoices AS T2 ON T1.id = T2.customer_id WHERE T1.first_name = "Lucas" AND T1.last_name = "Mancini"