Hello!  Can you please show me a list of all of the product names and their associated product IDs?
select t1.product_id,t1.product_name from products as t1 join ref_product_categories as t2 on t1.product_category_code = t2.product_category_code
Thank you very much!  Can you filter this list to show only the item with the product id of 11, and show me the associated product category code?
select t1.product_id,t1.product_name,t1.product_category_code from products as t1 join ref_product_categories as t2 on t1.product_category_code = t2.product_category_code where t1.product_id = 11
Thank you very much!  Can you update this to display the product category code, product category description, and unit of measure?
select t2.product_category_code,t2.product_category_description, t2.unit_of_measure from products as t1 join ref_product_categories as t2 on t1.product_category_code = t2.product_category_code where t1.product_id = 11