First of all, see my comment to your post.
If you want to count ID's
SELECT COUNT(ID) AS [CountOfID's]
FROM YourTable
or
SELECT COUNT(DISTINCT ID) AS [CountOfID's]
FROM YourTable
Analogically,
if you want to count MemebrID's
SELECT COUNT(MemberID) AS [CountOfMemberID's]
FROM YourTable
or
SELECT COUNT(DISTINCT MemberID) AS [CountOfMemberID's]
FROM YourTable
Finally,
if you want to count MemberID's for each ID
SELECT ID, COUNT(MemberID) AS [CountOfMemberID's]
FROM YourTable
or
SELECT ID, COUNT(DISTINCT MemberID) AS [CountOfMemberID's]
FROM YourTable