Why a LEFT JOIN reports 100% activation when three users never activated

Suppose you're analysing a project-management app. People sign up to organise their work, but some leave without creating a project. You want to know how many new users take that first step within sev