I have the following query. I'd like to adjust to select only those user\_ids that have multiple subscription\_plans. As an example if a user\_id 4 has just one subscription\_plan\_id of, he shouldn't show up.

If user\_id 5 has subscription\_plan\_id of 2 and 3, he should show up. Any advice on how to do this?

```
select user_id, subscription_plan_id, created_at from
subscriptions where 
(subscription_plan_id = 47 or 
subscription_plan_id = 78)
and created_at between '2014-01-01' and '2014-01-31';

```