gistfile1.txt

SQL> select count(*) a, okcfc1, cttx40 from oohead left join ocusma on oacuno=okcuno left join csytab on ctstco='CFC1' and ctstky=okcfc1 where oaadid='ÚÚÚÚÚÚ' and oaordt like '2014%' group by okcfc1, cttx40 order by a desc
+------------+-----------+-----------------------------------------+
| A          | OKCFC1    | CTTX40                                  |
+------------+-----------+-----------------------------------------+
| 152        | 400DC     | André Myriam                           |
| 91         | 400VK     | Morand Stéphanie                       |
| 57         | 400M1     | Valcroze Sandrine                       |
| 42         | 400F1     | Ivars Amandine                          |
| 36         | 400ND     | Deschamp Nelly                          |
| 32         | 400Y1     | Nguyen Véronique                       |
| 23         | 400V3     | Millet Daniel                           |
| 8          | 400G2     | Peillet Aurélie                        |
| 5          | 212ED     | BARBARA DEMOULIN                        |
| 1          | 105FR     | MARTINE                                 |
| 1          | 400A8     | Narwa Véronique                        |
+------------+-----------+-----------------------------------------+