"Неправильный синтаксис около ключевого слова end"

FROM Stand INNER JOIN Gost ON Stand.Gost_Id=Gost.Gost_IdINNER JOIN OKP ON Stand.Okp_Id=Okp.Okp_Idorder BY len(SGName)

DECLARE @stand TABLE (stand_id INT IDENTITY(1,1), mark nvarchar(5));
DECLARE @gost TABLE (gost_id INT, [name] nvarchar(15));
DECLARE @okp TABLE (okp_id INT, klass nvarchar(10), naim tinyint);
 
INSERT INTO @stand (mark) SELECT ('M0001')
INSERT INTO @stand (mark) SELECT ('M0002')
INSERT INTO @stand (mark) SELECT ('M0003')
INSERT INTO @stand (mark) SELECT ('M0004')
INSERT INTO @gost SELECT 1, 'Gost_0001';
INSERT INTO @gost SELECT 2, 'Gost_0002';
INSERT INTO @gost SELECT 1, 'Gost_0003';
INSERT INTO @gost SELECT 3, 'Gost_0004';
INSERT INTO @gost SELECT 4, 'Gost_0005';
INSERT INTO @okp SELECT 1, 'Class_0001', 0;
INSERT INTO @okp SELECT 2, 'Class_0002', 1;
INSERT INTO @okp SELECT 1, 'Class_0003', 1;
INSERT INTO @okp SELECT 3, 'Class_0004', 0;
INSERT INTO @okp SELECT 1, 'Class_0005', 1;
INSERT INTO @okp SELECT 4, 'Class_0006', 0;
 
SELECT
    s.*,
    gost_id AS gostid,
    g.name AS gostname,
    s.mark AS standmark,
    okp_id AS okpip,
    o.klass,
    naim
FROM @stand AS s
INNER JOIN @gost AS g ON s.stand_id = g.gost_id
INNER JOIN @okp AS o ON o.okp_id = s.stand_id
ORDER BY stand_id