With the E-R Diagram below, how would I write this SQL statement?

Find out (1) the number of the people whose earnings increased, (2) the number of those whose earnings decreased, (3) the ratio of (# of earning increased : # of earning decreased), (4) the average earning changing rate of for the workers in a specific business sector (use attribute primary sector in table Company. [Hint: earning change = the sum of a persons current income the sum of the persons earning when he/she was holding his/her the latest previous job position. For (4), only count the earning from the specified sector (companies primary sector)]

Bryan Zheng Randy Phan Section Person Position PK c code takes PK per ld PK pos code emp_mode (required sll) pay rate PK year zip code complele date offered by format price ernail cate code phone hns skil has Knowledge Job_category PK e code PK k code PK cate code tite ks trle ks dosoription ks level title dosciptiorn pay range high pay range low (oore skill retail price Company PK comp id hires pimary secior NAICS Bryan Zheng Randy Phan Section Person Position PK c code takes PK per ld PK pos code emp_mode (required sll) pay rate PK year zip code complele date offered by format price ernail cate code phone hns skil has Knowledge Job_category PK e code PK k code PK cate code tite ks trle ks dosoription ks level title dosciptiorn pay range high pay range low (oore skill retail price Company PK comp id hires pimary secior NAICS