IN clause

Simple IN clause

Using IN clause with a subquery