Percentage between two columns in different tables with grouping

Hello everyone,    I am having an issue regarding the computation of what seemed trivial at first but has taken me way too long now. I have two tables with 4 columns each : three column that share...