+------------+--------+
| date       | status |
+------------+--------+
| 2005-10-01 |      1 |
| 2005-10-01 |      1 |
| 2005-10-02 |      3 |
| 2005-10-02 |      0 |
| 2005-10-03 |      0 |
| 2005-10-03 |      1 |
| 2005-10-03 |      2 |
| 2005-10-04 |      1 |
| 2005-10-06 |      3 |
+------------+--------+

+------------+--------+
| date       | value  |
+------------+--------+
| 2005-10-01 |      1 |
| 2005-10-02 |      3 |
| 2005-10-03 |      3 |
| 2005-10-04 |      1 |
| 2005-10-06 |      3 |
+------------+--------+

SELECT
 tbl.date AS "Date",
 CASE
  WHEN AND(tbl.status) = 1 THEN 1
  WHEN AND(tbl.status) = 2 THEN 2
  WHEN OR(tbl.status) = 3 THEN 3
  WHEN (AND(tbl.status) = 1 OR AND(tbl.status) = 2) THEN 3
  ELSE 0
 END
  AS "Value"
FROM
 tbl
GROUP BY
 tbl.date

SELECT 
	date,
	CASE
		WHEN smin = smax AND smax = 1 THEN 1
		WHEN smin = smax AND smax = 2 THEN 2
		WHEN FIND_IN_SET('3', sall) THEN 3
		WHEN FIND_IN_SET('1', sall) AND FIND_IN_SET('2', sall) THEN 3
		ELSE 0
	END AS value
FROM (
	SELECT
		date AS date, 
	 	MIN(status) AS smin,
	 	MAX(status) AS smax,
	 	GROUP_CONCAT(DISTINCT status SEPARATOR ',') AS sall
	 FROM request
	 GROUP BY date
) AS r

ORDER BY date;