Select INNER or LEFT JOIN from the business question, not habit.
Jules compares signups to first purchases and reports a 100 percent conversion rate. The query used INNER JOIN, so everyone who never purchased disappeared before the ratio was calculated.
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in