Code what you know
Know what you code
First principles:
If you don’t really understand what the tables and/or views represent, the SQL will likely perform poorly,…
and even if it doesn’t, it will likely be functionally wrong!