Which color descriptions contain the letter 't'?
select color_description from ref_colors where color_description like '%t%'
Give for product descriptions instead?
select product_description from products where product_description like '%t%'
What are the units of measure for these products?
select t1.unit_of_measure 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%'
Give their category descriptions instead.
select t1.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%'