mysql> create table obl_kgp (kgp varchar( 20 ), org varchar( 30 ));

insert into obl_kgp values ( "1001234 ",  "Astr. obl." );
insert into obl_kgp values ( "1003709 ",  "Astr. obl." );
insert into obl_kgp values ( "1001209 ",  "Astr. obl." );
insert into obl_kgp values ( "0233709 ",  "Bur. obl." );

select * from obl_kgp;
+ ---------+------------+
 
| kgp     | org        |
+ ---------+------------+
 
|  1001234  | Astr. obl. |
|  1003709  | Astr. obl. |
|  1001209  | Astr. obl. |
|  0233709  | Bur. obl.  |
+ ---------+------------+
 

SELECT ORG, LEFT(KGP, 5 ), COUNT(DISTINCT LEFT(KGP, 5 ))
FROM obl_kgp
GROUP BY ORG;

+ ------------+-------------+-----------------------------+
 
| ORG        | LEFT(KGP, 5 ) | COUNT(DISTINCT LEFT(KGP, 5 )) |
+ ------------+-------------+-----------------------------+
 
| Astr. obl. |  10012        |                            2  |
| Bur. obl.  |  02337        |                            1  |
+ ------------+-------------+-----------------------------+