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
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
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 value
Return the color description that is most common across all products .