MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table myTable (
    name        text,
    place       text,
    code        text,
    status      text,
    problemCode int
) 
insert into myTable 
values 
-- name   place code status problemCode
('bill',  'kc', 'a', 'b',   0),
('bill',  'kc', 'a', 'b',   0),
('paul',  'nz', 'c', 'd',   1),
('paul',  'nz', 'c', '1',   1),
('george','uk', 'e', '1',  99);
SELECT 
    name, 
    place,
    code,
    COUNT(DISTINCT(IF( status='1' ) ,problemCode,0)) AS countIssues -- misplaced paren
FROM myTable
GROUP BY code, (case when countIssues > 0 then problemCode end)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ,problemCode,0)) AS countIssues -- misplaced paren
FROM myTable
GROUP BY code,' at line 5

SELECT 
    name, 
    place,
    code,
    COUNT(DISTINCT(IF( status='1' ,problemCode,0))) AS countIssues -- better paren
FROM myTable
GROUP BY code, (case when countIssues > 0 then problemCode end) -- but you need to "GROUP BY" properly
Can't group on '???'

SELECT 
    name, 
    place,
    code,
    COUNT(DISTINCT(IF( status='1' ,problemCode,0))) AS countIssues
FROM myTable
GROUP BY code, 
         place,
         name
-- cool, it runs now, start debugging here


name
place
code
countIssues


bill
kc
a
1

paul
nz
c
2

george
uk
e
1


select * 
from (
    SELECT 
        name, 
        place,
        code,
        COUNT(DISTINCT(IF( status='1' ,problemCode,0))) AS countIssues
    FROM myTable
    GROUP BY code, 
             place,
             name
) x
where countIssues > 1
-- hmm... 🤔 still seems a little nonsensical
-- but this is a good starting point to ask a good question


name
place
code
countIssues


paul
nz
c
2