-- Database schema
| Ref_Characteristic_Types : characteristic_type_code [ TEXT ] primary_key , characteristic_type_description [ TEXT ] | Ref_Colors : color_code [ TEXT ] primary_key , color_description [ TEXT ] | Ref_Product_Categories : product_category_code [ TEXT ] primary_key , product_category_description [ TEXT ] , unit_of_measure [ TEXT ] | Characteristics : characteristic_id [ INT ] primary_key , characteristic_type_code [ TEXT ] Characteristics.characteristic_type_code = Ref_Characteristic_Types.characteristic_type_code , characteristic_data_type [ TEXT ] , characteristic_name [ TEXT ] , other_characteristic_details [ TEXT ] | Products : product_id [ INT ] primary_key , color_code [ TEXT ] Products.color_code = Ref_Colors.color_code , product_category_code [ TEXT ] Products.product_category_code = Ref_Product_Categories.product_category_code , product_name [ TEXT ] , typical_buying_price [ TEXT ] , typical_selling_price [ TEXT ] , product_description [ TEXT ] , other_product_details [ TEXT ] | Product_Characteristics : product_id [ INT ] Product_Characteristics.product_id = Products.product_id , characteristic_id [ INT ] Product_Characteristics.characteristic_id = Characteristics.characteristic_id , product_characteristic_value [ TEXT ] |
-- -- Return the color description that is most common across all products.

SELECT t2.color_description FROM products AS t1 JOIN ref_colors AS t2 ON t1.color_code  =  t2.color_code GROUP BY t2.color_description ORDER BY count(*) DESC LIMIT 1;