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.