Hello, I am looking for assistance creating a query. I need to count the number of distinct records based on the name of the record and rated by category. See sample below.
SELECT DISTINCT COUNT(*) AS Count, [Category]
FROM [table name]
WHERE NAME LIKE [Name]
GROUP BY [Category]
I want to list the following columns
Count| Name| Category