How to write child-to-parent relationship queries in SOQL using dot notation and the difference between standard and custom relationship names (__r suffix)