test sub query in IN clause.