select DivDesc, ModelDesc, ModelID, ModelType, ModelImage, Max(YearDesc) as YearDesc,Min(MSRP) as MSRP from vw_AutoData_Trims where CountryCode='CA' and LngCode='EN' and Cast(YearDesc as numeric) >= 2010 and DivDesc='Jeep' group by DivDesc, ModelDesc, ModelID,ModelType, ModelImage order by DivDesc,YearDesc Desc,ModelDesc