I have an object which captures searches made by users. It has a Searc_Phrase__c field. Each record captures one search attempt - the phrase, the use id and the date.
I want to query how many times each phrase was used in a search but count only unique users e.g. if a user searched multiple time for the same phrase count only 1.
Can I do that with SOQL?