Hi there, I hope your help.

I get a subtotal and total in the same query and tried this solution, but I need this other output, can you help me?
thank you.
Code:
+--------------------+------------------+---------------+-----------+--------------+-----------------+----------------------+
| Day_of_the_event_s | DescriptionEven  | number_events | tot_CC80  | lines_tb_tni | tot_clients_int | Duration_of_theEvent |
+--------------------+------------------+---------------+-----------+--------------+-----------------+----------------------+
| 2013-01-08         | NUXXX            |             2 | 99.15     | 2            | 36              | 134                  |
| 2013-01-08         | CAXXX            |             5 | 96.29     | 5            | 188             | 88                   |
| 2013-01-08         | TIXXX            |             2 | 85.30     | 2            | 64              | 143                  |
| 2013-01-08         | AVXXX            |             1 | 76.00     | 1            | 151             | 76                   |
| 2013-01-08         | LUXXX            |             1 | 52.00     | 1            | 38              | 52                   |
| 2013-01-08         | subtotal         |            11 | 408.74    | 36           | 1637            | 2867                 |
| 2013-01-07         | TEXXX            |             4 | 837.94    | 4            | 181             | 472                  |
| 2013-01-07         | LAXXX            |             3 | 824.00    | 3            | 276             | 59                   |
| 2013-01-07         | ATXXX            |             1 | 82.00     | 1            | 77              | 82                   |
| 2013-01-07         | CAXXX            |            16 | 3069.45   | 16           | 1029            | 1660                 |
| 2013-01-07         | CSXXX            |            15 | 2254.22   | 15           | 841             | 1165                 |
| 2013-01-07         | subtotal         |            40 | 7067.61   | 206          | 12145           | 19831                |
|                    | total            |            51 | 7476.35   | 242          | 13782           | 22698                |
+--------------------+------------------+---------------+-----------+--------------+-----------------+----------------------+
Code:
mysql> SELECT
	Day_of_the_event_s,
        DescriptionEven,
	number_events,
	COALESCE (tot_CC80, 'Tot') tot_CC80,
	lines_tb_tni,
	tot_clients_int,
	Duration_of_theEvent
FROM
	(
		SELECT
			Day_of_the_event_s,
                        DescriptionEven,
			COUNT(*) AS number_events,
			SUM(cc80) AS tot_CC80,
			SUM(lines_tb_tni) AS lines_tb_tni,
			SUM(
				tot_clients_int
			) AS tot_clients_int,
			SUM(Duration_of_theEvent) AS Duration_of_theEvent
		FROM
			tbl_cc80
		GROUP BY
			Day_of_the_event_s,
			Description_event WITH ROLLUP
	) qw
ORDER BY
	Day_of_the_event_s DESC,
	tot_CC80 DESC;
+--------------------+------------------+---------------+-----------+--------------+-----------------+----------------------+
| Day_of_the_event_s | DescriptionEven  | number_events | tot_CC80  | lines_tb_tni | tot_clients_int | Duration_of_theEvent |
+--------------------+------------------+---------------+-----------+--------------+-----------------+----------------------+
| 2013-01-08         | NUXXX            |             2 | 99.15     | 2            | 36              | 134                  |
| 2013-01-08         | CAXXX            |             5 | 96.29     | 5            | 188             | 88                   |
| 2013-01-08         | TIXXX            |             2 | 85.30     | 2            | 64              | 143                  |
| 2013-01-08         | AVXXX            |             1 | 76.00     | 1            | 151             | 76                   |
| 2013-01-08         | NULL             |            11 | 408.74    | 36           | 1637            | 2867                 |
| 2013-01-08         | LUXXX            |             1 | 52.00     | 1            | 38              | 52                   |
| 2013-01-07         | TEXXX            |             4 | 837.94    | 4            | 181             | 472                  |
| 2013-01-07         | LAXXX            |             3 | 824.00    | 3            | 276             | 59                   |
| 2013-01-07         | ATXXX            |             1 | 82.00     | 1            | 77              | 82                   |
| 2013-01-07         | NULL             |            40 | 7067.61   | 206          | 12145           | 19831                |
| 2013-01-07         | CAXXX            |            16 | 3069.45   | 16           | 1029            | 1660                 |
| 2013-01-07         | CSXXX            |            15 | 2254.22   | 15           | 841             | 1165                 |
+--------------------+------------------+---------------+-----------+--------------+-----------------+----------------------+
12 rows in set