Amazon Business Intelligence Engineer I interview questions

Below is an interview result. The program cycle is half of a year and June is the month of renewal. <Total count> Group | June | July | -------+------+------| drop | 25 | 0 | new | 0 | 20 | stay | 30 | 30 | Total | 55 | 50 | <Positive count> Group | June | July | -------+------+------| drop | 15 | 0 | new | 0 | 11 | stay | 20 | 18 | Total | 35 | 29 | <Positive rate> Group | June | July | -------+------+------| drop | 60% | 0% | new | 0% | 55% | stay | 67% | 60% | Total | 64% | 58% | 1) July positive ratio is decreased -6%. Create contribution bridge of each group (change to contribution). 2) Which group is the most negative impact on the rate change (-6%)? 3) Please make a bridge as below. -6% descrease was mainly due to XX group XX%, YY group YY% and ZZ group ZZ%, respectively (you can change sentences if you want).