I am not entirely sure I follow what you are after. This article will provide you some help tips on how to post your problem correctly, so members are more likely to assist in solving your problem. Not only will more people help you with your problem we will be able to better understand the issue at hand rather than making guesses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
1. get only the optional subscriptions (in this case: all subscriptions above 50).
2. get only the effective subscriptions (<= 50)
The simple answer would be to say the following, but I do not know enough about your problem to be accurate.
SELECT *
FROM TABLE
WHERE SUBSCRIPTIONS > 50
AND
SELECT *
FROM TABLE
WHERE SUBSCRIPTIONS <=50