---

SELECT TOP 10 ts.* 
FROM Transportnoe_Sredstvo ts
JOIN Kategoriya k ON ts.Kod_Kategorii = k.Kod_Kategorii
WHERE k.Kolichestvo_Mest = 7
ORDER BY ts.Stoimost_Prokata DESC;