I have this query: 

```
SELECT Count(*) AS GesamtanzahlMitarbeiter, 
(SELECT Count(*) FROM EMP WHERE HIREDATE LIKE '%80') AS "1980", 
(SELECT Count(*) FROM EMP WHERE HIREDATE LIKE '%81') AS "1981", 
(SELECT Count(*) FROM EMP WHERE HIREDATE LIKE '%82') AS "1982", 
(SELECT Count(*) FROM EMP WHERE HIREDATE LIKE '%83') AS "1983"  
FROM EMP 
GROUP BY DEPTNO;

```

And I get this Output:

```
GESAMTANZAHLMITARBEITER       1980       1981       1982       1983
----------------------- ---------- ---------- ---------- ----------
                      6          1         10          2          1
                      5          1         10          2          1
                      3          1         10          2          1

```

Now the Point is, that I don't want to group by deptno. I want to Group them all and count all the "GESAMTANZAHLMITARBEITER" like this:

```
GESAMTANZAHLMITARBEITER       1980       1981       1982       1983
----------------------- ---------- ---------- ---------- ----------
                     14          1         10          2          1

```

But I cannot GROUP BY \* or something..
A workaround would be to give them all a new attribute with the same value and group by that attribute, but thats just not right. 

I have no Idea how to do that...