Table a
Id name all
1... Development zone... 100
2... Geng car... 10
3... Port son... 10
4... The canal port... 10


Table b
Id no name
1... 111... Geng car
2... 121... Development zone
3... 222... Development zone
4... 131... Port child
5... 333... The canal port
6... 341... Development zone
7... 444... Development zone
8... 161... Port child

Want
Id name all count (no) of
1... Development zone... 100... . 4... . 0.04
2... Geng car... 10... . 1... . 0.1
3... Port son... 10... . 2... . 0.2
4... The canal port... 10... . 1... . 0.1