Hi everyone,

I'm working on the Use Advanced SQL Techniques challenge in the Data 360 module and I'm stuck on the final challenge validation.

Module: 

The challenge asks us to create a complex Data 360 SQL query using a CTE (account_risk) and a subquery, then join Accounts, Individuals, and Contact Point Email records.

I tried the following approach:

WITH account_risk AS (
    SELECT
        account."ssot__Id__c",
        account."ssot__Name__c"
    FROM "ssot__Account__dlm" account
    WHERE EXISTS (
        SELECT 1
        FROM "ssot__Opportunity__dlm" opportunity
        WHERE opportunity.<account_field> = account."ssot__Id__c"
          AND opportunity."ssot__IsClosed__c" = 'false'
          AND opportunity."ssot__Probability__c" <= 50
    )
)
SELECT
    individual."ssot__FirstName__c",
    individual."ssot__LastName__c",
    email."ssot__EmailAddress__c",
    risk."ssot__Name__c"
FROM account_risk risk
INNER JOIN "ssot__Individual__dlm" individual
    ON risk."ssot__Id__c" = individual."ssot__PrimaryAccountId__c"
INNER JOIN "ssot__ContactPointEmail__dlm" email
    ON individual."ssot__Id__c" = email."ssot__PartyId__c"

The query runs, but the challenge validator returns:

Has anyone completed this challenge recently and can confirm:

1. Which Opportunity-to-Account field should be used?
2. Whether ssot__IsClosed__c should be compared as a text value or boolean?
3. If the validator requires a specific join order or exact field names beyond what's listed in the instructions?

Any guidance would be appreciated. Thanks!