Need help with UNIQUE values in query

Need help with UNIQUE values in query

We are trying to return a single list of unique our departments with a "status" if all reports were not received for a given quarter.  Eg.



However if previous quarters status was "red", then it duplicates the department/country as shown below:



Below is the query:
  1. SELECT UNIQUE
  2.  t1."Country" "Country",
  3.  CASE
  4.   WHEN month(t1."Report Date") BETWEEN 10 AND 12 
  5.   THEN 'red' 
  6. END AS "Q1",

  7.  CASE
  8.   WHEN month(t1."Report Date") BETWEEN 1 AND 3 
  9.   THEN 'red' 
  10. END AS "Q2",

  11.  CASE
  12.   WHEN month(t1."Report Date") BETWEEN 4 AND 6 
  13.   THEN 'red' 
  14. END AS "Q3",

  15.  CASE
  16.   WHEN month(t1."Report Date") BETWEEN 7 AND 9
  17.   THEN 'red' 
  18. END AS "Q4"

  19. FROM "CRS" t1, "FY" t5

  20. WHERE t1."Ignore" = 'false'
  21.  AND t1."Received" = 'false'
  22.  AND t1."Report Date" BETWEEN t5."FYBegin" AND t5."FYEnd"