CREATE TABLE addresses (address_id DECIMAL, address_content TEXT, city TEXT, zip_postcode TEXT, state_province_county TEXT, country TEXT, other_address_details TEXT)
CREATE TABLE products (product_id DECIMAL, product_details TEXT)
CREATE TABLE order_items (order_id DECIMAL, product_id DECIMAL, order_quantity TEXT)
CREATE TABLE customer_orders (order_id DECIMAL, customer_id DECIMAL, order_status TEXT, order_date TIME, order_details TEXT)
CREATE TABLE customer_addresses (customer_id DECIMAL, address_id DECIMAL, date_address_from TIME, address_type TEXT, date_address_to TIME)
CREATE TABLE customers (customer_id DECIMAL, payment_method TEXT, customer_name TEXT, date_became_customer TIME, other_customer_details TEXT)
CREATE TABLE customer_contact_channels (customer_id DECIMAL, channel_code TEXT, active_from_date TIME, active_to_date TIME, contact_number TEXT)

Find the number of distinct products Rodrick Heaney has bought so far.
SELECT COUNT(DISTINCT t3.product_id) FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id = t2.customer_id JOIN order_items AS t3 ON t2.order_id = t3.order_id WHERE t1.customer_name = "Rodrick Heaney"
SELECT COUNT(DISTINCT "t3"."product_id") FROM "customers" AS "t1" JOIN "customer_orders" AS "t2" ON "t1"."customer_id" = "t2"."customer_id" JOIN "order_items" AS "t3" ON "t2"."order_id" = "t3"."order_id" WHERE "Rodrick Heaney" = "t1"."customer_name"