SQL Concat and Substring

SELECT
 C.Cust_Name,
I.ItemName,
I.Price
FROM Customers C
INNER JOIN Orders O
ON C.CustomerID = O.CustomerID
INNER JOIN Items I
ON O.ItemID = I.ItemID
WHERE I.Price >
 (SELECT TOP 1
    I.Price
  FROM Customers C
  INNER JOIN Orders O
  ON C.CustomerID = O.CustomerID
  INNER JOIN Items I
  ON O.ItemID = I.ItemID
  WHERE Cust_Name = 'Badang'

  )
  ORDER BY Price

  SELECT TOP 11 (SELECT CONCAT ('Lab_OR-##',
             (SELECT SUBSTRING (OrderID, 5,3))))
             AS 'New OrderID', Cust_Name, Address, ItemName, Price
             FROM Customers C