18.10Scenario 9 — Contact plus Account

Prompt:

“Find active contacts and return the parent Account name.”

SELECT
    Id,
    FirstName,
    LastName,
    Email,
    Account.Id,
    Account.Name
FROM Contact
WHERE Account.Customer_Status__c = 'ACTIVE'

This demonstrates relationship traversal.