10 / 81 · Module 5 — Salesforce Data Model + SOQL · filtered: interview← prev ⊞ all next →

5.45Scenario 4 — Open Opportunities

Retrieve open Opportunities over $100,000 for active Accounts.

Conceptually:

SELECT
    Id,
    Name,
    Amount,
    StageName,
    Account.Id,
    Account.Name
FROM Opportunity
WHERE Amount > 100000
AND IsClosed = FALSE
AND Account.Status__c = 'Active'

You don't need to know every standard Opportunity field by memory; the relationship/query pattern is the important part.