5.21Filtering using the parent
Suppose interviewer says:
Get all Contacts whose Account is in Florida.
SELECT
Id,
FirstName,
LastName,
Email,
Account.Name
FROM Contact
WHERE Account.BillingState = 'FL'
This is the answer I want you to immediately recognize.
No:
JOIN Account...
Instead:
Contact → Account relationship