CREATE TABLE invoices (billing_state VARCHAR2, total NUMBER)

List the number of invoices and the invoice total from California.
SELECT billing_state, COUNT(*), SUM(total) FROM invoices WHERE billing_state = "CA"
SELECT "billing_state", COUNT(*), SUM("total") FROM "invoices" WHERE "CA" = "billing_state"