What are the product names in decreasing order of typical selling price?
select product_name from products order by typical_selling_price desc
Order by decreasing order of color frequency instead.
select t1.product_name 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
Show their respective color descriptions.
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
Show only for the most frequent color description.
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