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:
https://trailhead.salesforce.com/content/learn/modules/data-exploration-with-data-360-sql-queries/use-advanced-sql-techniques?trail_id=data-360-develop-and-build-solutions&journey=data-360The 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:
- Which Opportunity-to-Account field should be used?
- Whether ssot__IsClosed__c should be compared as a text value or boolean?
- 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!
#Trailhead Challenges #Trailhead #Agentforce #Salesforce Developer #Salesforce #TrailblazerCommunity #Tableau Cloud #Tableau Public #Data Cloud #Trailhead Support
