SELECT
c.certificate_no,
count(c.`name`)
FROM
len_borrower_info c
GROUP BY
c.certificate_no
HAVING
count(c.`name`) > 1
c.certificate_no,
count(c.`name`)
FROM
len_borrower_info c
GROUP BY
c.certificate_no
HAVING
count(c.`name`) > 1