select u.name, count(*) as cnt from users u

left join point_users pu on u.user_id = pu.point_user_id 

where pu.point_user_id is not NULL

group by u.name

is NULL값은 나오는데 not을 붙이니까 값이 나오질 않습니다.

제가 뭘 잘못했나요?