select {TargetFrequency:_soup}, max({TargetFrequency:Last_Call_Report_Date__c}) from {TargetFrequency} where {TargetFrequency:Last_Call_Report_Date__c} is not null group by {TargetFrequency:Last_Call_Report_Date__c}