CREATE TABLE Product_Characteristics (product_id NUMBER, characteristic_id NUMBER, product_characteristic_value VARCHAR2)
CREATE TABLE Ref_Characteristic_Types (characteristic_type_code VARCHAR2, characteristic_type_description VARCHAR2)
CREATE TABLE Characteristics (characteristic_id NUMBER, characteristic_type_code VARCHAR2, characteristic_data_type VARCHAR2, characteristic_name VARCHAR2, other_characteristic_details VARCHAR2)
CREATE TABLE Ref_Colors (color_code VARCHAR2, color_description VARCHAR2)
CREATE TABLE Products (product_id NUMBER, color_code VARCHAR2, product_category_code VARCHAR2, product_name VARCHAR2, typical_buying_price VARCHAR2, typical_selling_price VARCHAR2, product_description VARCHAR2, other_product_details VARCHAR2)
CREATE TABLE Ref_Product_Categories (product_category_code VARCHAR2, product_category_description VARCHAR2, unit_of_measure VARCHAR2)

A bar chart for what are the number of the descriptions of the categories that products with product descriptions that contain the letter t are in?
SELECT product_category_description, COUNT(product_category_description) FROM Ref_Product_Categories AS T1 JOIN Products AS T2 ON T1.product_category_code = T2.product_category_code WHERE T2.product_description LIKE '%t%' GROUP BY product_category_description
SELECT "product_category_description", COUNT("product_category_description") FROM "Ref_Product_Categories" "T1" JOIN "Products" "T2" ON "T1"."product_category_code" = "T2"."product_category_code" AND "T2"."product_description" LIKE '%t%' GROUP BY "product_category_description"