display data from the database (summarizes data)

@DELE,

Getting income per country becomes a little trickier because you have multiple countries per record.  Does each country get the whole income_value or is it divided between the countries?

demo of data above [ http://sqlfiddle.com/#!9/a8074e/1 ]

divided between the countries.

the problem was resolved, I got what I wanted. I will post it here after my simple project is finished.