SELECT COUNT(*) FROM products AS t1 JOIN product_characteristics AS t2 ON t1.product_id = t2.product_id JOIN characteristics AS t3 ON t2.characteristic_id = t3.characteristic_id JOIN ref_colors AS t4 ON t1.color_code = t4.color_code WHERE t4.color_description = "white" OR t3.characteristic_name = "hot"
How many products have their color described as 'white' or have a characteristic with the name 'hot'?
CREATE TABLE product_characteristics (
    product_id number,
    characteristic_id number,
    product_characteristic_value text
)

CREATE TABLE ref_product_categories (
    product_category_code text,
    product_category_description text,
    unit_of_measure text
)

CREATE TABLE characteristics (
    characteristic_id number,
    characteristic_type_code text,
    characteristic_data_type text,
    characteristic_name text,
    other_characteristic_details text
)

CREATE TABLE ref_colors (
    color_code text,
    color_description text
)

CREATE TABLE ref_characteristic_types (
    characteristic_type_code text,
    characteristic_type_description text
)

CREATE TABLE products (
    product_id number,
    color_code text,
    product_category_code text,
    product_name text,
    typical_buying_price text,
    typical_selling_price text,
    product_description text,
    other_product_details text
)