What is the number of invoices and total money billed in them from CA?
CREATE TABLE artists (
    id number,
    name text
)

CREATE TABLE employees (
    id number,
    last_name text,
    first_name text,
    title text,
    reports_to number,
    birth_date time,
    hire_date time,
    address text,
    city text,
    state text,
    country text,
    postal_code text,
    phone text,
    fax text,
    email text
)

CREATE TABLE customers (
    id number,
    first_name text,
    last_name text,
    company text,
    address text,
    city text,
    state text,
    country text,
    postal_code text,
    phone text,
    fax text,
    email text,
    support_rep_id number
)

CREATE TABLE tracks (
    id number,
    name text,
    album_id number,
    media_type_id number,
    genre_id number,
    composer text,
    milliseconds number,
    bytes number,
    unit_price number
)

CREATE TABLE genres (
    id number,
    name text
)

CREATE TABLE media_types (
    id number,
    name text
)

CREATE TABLE sqlite_sequence (
    name text,
    seq text
)

CREATE TABLE playlist_tracks (
    playlist_id number,
    track_id number
)

CREATE TABLE invoice_lines (
    id number,
    invoice_id number,
    track_id number,
    unit_price number,
    quantity number
)

CREATE TABLE albums (
    id number,
    title text,
    artist_id number
)

CREATE TABLE playlists (
    id number,
    name text
)

CREATE TABLE invoices (
    id number,
    customer_id number,
    invoice_date time,
    billing_address text,
    billing_city text,
    billing_state text,
    billing_country text,
    billing_postal_code text,
    total number
)
SELECT billing_state, COUNT(*), SUM(total) FROM invoices WHERE billing_state = "CA"
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: What is the number of invoices and total money billed in them from CA? ### Input: CREATE TABLE artists (
    id number,
    name text
)

CREATE TABLE employees (
    id number,
    last_name text,
    first_name text,
    title text,
    reports_to number,
    birth_date time,
    hire_date time,
    address text,
    city text,
    state text,
    country text,
    postal_code text,
    phone text,
    fax text,
    email text
)

CREATE TABLE customers (
    id number,
    first_name text,
    last_name text,
    company text,
    address text,
    city text,
    state text,
    country text,
    postal_code text,
    phone text,
    fax text,
    email text,
    support_rep_id number
)

CREATE TABLE tracks (
    id number,
    name text,
    album_id number,
    media_type_id number,
    genre_id number,
    composer text,
    milliseconds number,
    bytes number,
    unit_price number
)

CREATE TABLE genres (
    id number,
    name text
)

CREATE TABLE media_types (
    id number,
    name text
)

CREATE TABLE sqlite_sequence (
    name text,
    seq text
)

CREATE TABLE playlist_tracks (
    playlist_id number,
    track_id number
)

CREATE TABLE invoice_lines (
    id number,
    invoice_id number,
    track_id number,
    unit_price number,
    quantity number
)

CREATE TABLE albums (
    id number,
    title text,
    artist_id number
)

CREATE TABLE playlists (
    id number,
    name text
)

CREATE TABLE invoices (
    id number,
    customer_id number,
    invoice_date time,
    billing_address text,
    billing_city text,
    billing_state text,
    billing_country text,
    billing_postal_code text,
    total number
) ### Response: SELECT billing_state, COUNT(*), SUM(total) FROM invoices WHERE billing_state = "CA"