Task: Text to Code
Input (English): SQL: SELECT Sum ( total ) , Sum ( total ) FROM invoices
Feedback: Replace "summation of total with number of rows of invoices table .
Output (English): SELECT billing_state ,  COUNT(*) ,  SUM(total) FROM invoices WHERE billing_state  =  "CA"