Subqueries_View

CREATE VIEW Subqueries_View
AS

SELECT  (SELECT CONCAT ('Lab_OR',
             (SELECT SUBSTRING (OrderID,3,len (OrderID)-2))))
             AS 'New OrderID', Cust_Name, Address, ItemName, Price

  FROM Customers C
  INNER JOIN Orders O
  ON C.CustomerID=O.CustomerID
  INNER JOIN Items I
  ON O.ItemID = I.ItemID
  WHERE price >
  (SELECT MAX(price)AS mp
  FROM orders o
  INNER JOIN items i ON i.itemid=o.itemid
  INNER JOIN customers c ON c.customerid=o.customerid
  WHERE Address IN ('Laguna','Taguig','Navotas')
  )