SELECT v$.$VehYear AS Year, v$.$VehColor AS Color, man.ManufacturerName, m$.$ModelName, t$.$TrimName, CAST$($i$.$InvRetail AS DECIMAL$(10,2))$ AS Price

FROM $(((($ Manufacturer man INNER JOIN Model m

ON man.ManufacturerID $=$ m$.$ManufacturerID

$)$ INNER JOIN Trim t

ON m$.$ModelID $=$ t$.$ModelID

$)$ INNER JOIN Vehicle v

ON t$.$TrimID $=$ v$.$TrimId

$)$ INNER JOIN Inventory i

ON i$.$VehId $=$ v$.$VehID

$)$

WHERE v$.$VehMilage $=0$

AND v$.$VehYear $=2020$;