Hello guys,
I have the below query in the "High Value Customers" workspace but still cannot accomplish the challange. Any hint what I might doing wrong here please? Many thanks!
SELECT
individual.ssot__FirstName__c
FROM
ssot__individual__dlm as individual
INNER JOIN
ssot__Account__dlm as account
ON
individual.ssot__PrimaryAccountId__c = account.ssot__Id__c
WHERE
account.ssot__AnnualRevenueAmount__c > 500000000
#Trailhead Challenges #Data Cloud #SQL Queries Topic #Sql Queries #Query Editor
Just removed AS in aliases and completed the module :)
SELECT
individual.ssot__FirstName__c
FROM
ssot__individual__dlm individual
INNER JOIN
ssot__Account__dlm account
ON
individual.ssot__PrimaryAccountId__c = account.ssot__Id__c
WHERE
account.ssot__AnnualRevenueAmount__c > 500000000
