Can any of these joins multiply rows?
Totals look inflated and you suspect the join before the data.
Shortsqljoinscorrectness
For each join in this query, say yes or no: can it multiply rows? Name the side whose key is not unique.
Query:
Making it yours
- Paste your own material where the prompt asks for it. Everything above that line is instruction, not content.
- Delete any rule that does not apply to you. A shorter prompt that fits beats a thorough one that does not.
- If the answer comes back vague, add a line saying what you do not want. Constraints work better than encouragement.
Correctness checks. Catching the join that duplicates rows, the NULL that drops them, and the GROUP BY that lies.
Keep this one
Promptory saves prompts with a right-click and puts them back the same way. Add this to your own library in one click.
Add to your browser — free