how many products are there
select count ( * ) from products
what is the product name of color code 2
select product_name from products where color_code = 2
what is the characteristic data type of characteristic id 1
select characteristic_data_type from characteristics where characteristic_id = 1