You should use DISTINCT keyword at first after the SELECT keyword, and remove the parenthesis,or if you need to categorize some of it, use GROUP BY functions. hope you're getting the desired result.
DISTINCT
SELECT
GROUP BY