Sub-Select with using of operator IN

The following query returns the orders that contain "Queso Cabrales" (ProductID=11) product:

SELECT
        O.OrderID, O.OrderDate, O.CustomerID
FROM
        dbo.Orders O
WHERE
        O.OrderID IN (
                SELECT OD.OrderID
                FROM dbo.[Order Details] OD
                WHERE
                        OD.ProductID =  11
        )