Get order by order id

NorthWind2020SingleOrder.sql

DECLARE @OrderIdentifier INT= 10248;
SELECT O.OrderID, 
       O.CustomerIdentifier, 
       O.EmployeeID, 
       E.Title + ' ' + E.FirstName + ' ' + E.LastName AS Employee, 
       O.OrderDate, 
       O.RequiredDate, 
       O.ShippedDate, 
       O.ShipVia, 
       O.Freight, 
       O.ShipAddress, 
       O.ShipCity, 
       O.ShipRegion, 
       O.ShipPostalCode, 
       O.ShipCountry
FROM Orders AS O
     INNER JOIN Employees AS E ON O.EmployeeID = E.EmployeeID
WHERE O.OrderID = @OrderIdentifier;