how to find duplicate count without counting original
ID | Name  | Email
1  | Mike  | x@q.com
2  | Peter | p@q.com
3  | Mike  | x@q.com
4  | Mike  | x@q.com
5  | Frank | f@q.com
6  | Jim   | f@q.com

SELECT value, count(lds1.leadid) FROM leads_form_element lds1 LEFT JOIN leads lds2 ON lds1.leadID = lds2.leadID
     WHERE lds2.typesID = "31" AND lds1.formElementID = '97'
     GROUP BY lds1.value HAVING ( COUNT(lds1.value) > 1 )

select count(*) from someTable;
select count(distinct Email) from someTable;

select (count(*)-(count(distinct Email))) from someTable

select sum(tot)
from
(
    select email, count(1)-1 as tot
    from table
    group by email
    having count(1) > 1
)