Date currentDate = new Date();
Date pastDate = DateUtils.addDays(currentDate, -7); //минус 7 дней от текущей даты
int min = TimeUnit.MILLISECONDS.toMinutes(currentDate.getTime()-pastDate.getTime());
SELECT COUNT(*) FROM
(SELECT subscribers.id
FROM subscribers INNER JOIN subscriptions ON subscribers.id = subscriptions.subscribers_id
GROUP BY subscribers.id
HAVING COUNT(subscriptions.id) > 2) AS counts;