Unable to validate sql in calculated insights

Getting the below errors when checking syntax - any ideas? 

SELECT COUNT(External_Abandoned_Cart_c_Home__dlm.Id__c) as NumberOfAbandons__c, 

External_Abandoned_Cart_c_Home__dlm.Guest_ID_c__c as CartGuestID__c 

FROM ssot__Individual__dlm 

INNER JOIN External_Abandoned_Cart_c_Home__dlm ON External_Abandoned_Cart_c_Home__dlm.Guest_ID_c__c = ssot__Individual__dlm.ssot__Id__c 

WHERE External_Abandoned_Cart_c_Home__dlm.CreatedDate__c >= DATE_ADD(CURRENT_DATE(),-14) 

GROUP BY CartGuestID__c 

Review your expression errors and try again.

1: Cannot find type for node External_Abandoned_Cart_c_Home__dlm.Id__c

2: Cannot find type for node External_Abandoned_Cart_c_Home__dlm.Guest_ID_c__c

3: Cannot find type for node External_Abandoned_Cart_c_Home__dlm.Guest_ID_c__c

4: Cannot find type for node ssot__Individual__dlm.ssot__Id__c

5: Cannot find type for node External_Abandoned_Cart_c_Home__dlm.CreatedDate__c

6: GREATER_THAN_OR_EQUAL operator must have the same type of arguments on both sides

7: Encountered problem while building Calculated Insight

8: undefined