5.22Interview scenario

Find Contacts belonging to active enterprise Accounts.

Assume Account fields:

Status__c
Customer_Tier__c

Then:

SELECT
    Id,
    FirstName,
    LastName,
    Email,
    Account.Id,
    Account.Name
FROM Contact
WHERE Account.Status__c = 'Active'
AND Account.Customer_Tier__c = 'Enterprise'

That's a very realistic integration query.