Ask what it's for
The question behind the request changes the analysis.
Because nobody asked what decision it was meant to support.
The strongest analysts ask questions before opening the database. What decision, by when, and what would change the answer — ten minutes that saves a week of work nobody uses.
Then SQL has to be correct and readable. A join that quietly duplicates rows produces a confident number that's wrong, which is worse than no number at all, and row-count checks catch it.
Finally the explanation. Answer first, method underneath, caveats stated plainly. Analysts who do this get asked better questions and get their findings acted on.
The question behind the request changes the analysis.
The quiet way joins produce wrong answers.
Anonymized samples or public datasets only.
Twenty minutes, free, on a query or a question you're stuck on.