---

SELECT * 
FROM Transportnoe_Sredstvo
WHERE Cvet = N'Красный';