Calculating % based on unique id and status

Dear community!   Recently I have faced with one problem, so needs your help.    I have one database, with unique id, regions and status, that looks like   and separate table with pop...