suzuko_aerio.sql

select bv.YearID, ma.MakeName, mo.ModelName, s.SubmodelName from Vehicle as v
join BaseVehicle as bv on v.BaseVehicleID = bv.BaseVehicleID
join Make as ma on bv.MakeID = ma.MakeID
join Model as mo on bv.ModelID = mo.ModelID
left join Submodel as s on v.SubmodelID = s.SubmodelID
where ma.MakeName = 'Suzuki' && bv.YearID = 2011
group by mo.ModelName
order by bv.YearID, mo.ModelName;