18.11Scenario 10 — Account with Contacts

Prompt:

“Retrieve Accounts and their Contacts.”

SELECT
    Id,
    Name,
    (
        SELECT
            Id,
            FirstName,
            LastName,
            Email
        FROM Contacts
    )
FROM Account

Remember:

child → parent
Account.Name

parent → children
(SELECT ... FROM Contacts)