How many addresses are there in country USA?
CREATE TABLE customer_orders (
    order_id number,
    customer_id number,
    order_date time,
    order_status_code text
)

CREATE TABLE customers (
    customer_id number,
    payment_method_code text,
    customer_number text,
    customer_name text,
    customer_address text,
    customer_phone text,
    customer_email text
)

CREATE TABLE customer_address_history (
    customer_id number,
    address_id number,
    date_from time,
    date_to time
)

CREATE TABLE contacts (
    contact_id number,
    customer_id number,
    gender text,
    first_name text,
    last_name text,
    contact_phone text
)

CREATE TABLE products (
    product_id number,
    product_type_code text,
    product_name text,
    product_price number
)

CREATE TABLE order_items (
    order_item_id number,
    order_id number,
    product_id number,
    order_quantity text
)

CREATE TABLE addresses (
    address_id number,
    line_1_number_building text,
    city text,
    zip_postcode text,
    state_province_county text,
    country text
)
SELECT COUNT(*) FROM addresses WHERE country = 'USA'
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: How many addresses are there in country USA? ### Input: CREATE TABLE customer_orders (
    order_id number,
    customer_id number,
    order_date time,
    order_status_code text
)

CREATE TABLE customers (
    customer_id number,
    payment_method_code text,
    customer_number text,
    customer_name text,
    customer_address text,
    customer_phone text,
    customer_email text
)

CREATE TABLE customer_address_history (
    customer_id number,
    address_id number,
    date_from time,
    date_to time
)

CREATE TABLE contacts (
    contact_id number,
    customer_id number,
    gender text,
    first_name text,
    last_name text,
    contact_phone text
)

CREATE TABLE products (
    product_id number,
    product_type_code text,
    product_name text,
    product_price number
)

CREATE TABLE order_items (
    order_item_id number,
    order_id number,
    product_id number,
    order_quantity text
)

CREATE TABLE addresses (
    address_id number,
    line_1_number_building text,
    city text,
    zip_postcode text,
    state_province_county text,
    country text
) ### Response: SELECT COUNT(*) FROM addresses WHERE country = 'USA'