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
A big thank you to @Shivam Srivastava for helping me resolve an issue I was facing with the "Use Advanced SQL Techniques" challenge in the Data 360 module.
I was stuck on the final challenge validation and couldn't figure out what was causing the problem. Shivam took the time to guide me through the issue and helped me get it resolved successfully.
Really appreciate your support, expertise, and willingness to help the Trailblazer community. Thank you, Shivam! 🙌