FIND 3RD HISGHEST COST FROM : [This is catalog table []


  [1]: https://i.stack.imgur.com/F4AML.png**so i have to find 3rd highest cost from this table .** i wrote this 
     SELECT TOP 1 COST FROM CATALOG WHERE COST IN
     (SELECT DISTINCT TOP 3 COST FROM CATALOG ORDER BY COST DESC)
     ORDER BY COST ASC;
    I GOT THIS ERROR' FROM KEYWORD NOT FOUND WHERE EXPECTED'
    PLEASE TELL ME WHAT IS THE ACTUAL QUERY .