select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)
In the sub query, '*' should be used instead of 'OrderID'
The sub query can return more than one row, so, '=' should be replaced with 'in'
The sub query should not be in parenthesis
None of the above