[sql]select brand_name , min(price)
from table_name
order by brand_name[/sql]