Graph one data original table



Figure 2 want to make table form




Difference rate formula





Great god the SQL how to write, please?

VX McS77920

QQ: 185878550

CodePudding user response:

Please only 7 to November data can be?

CodePudding user response:

Use MySQL roughly ideas: for example through December difference rate case statement WHEN the MONTH (date)=12 THEN SUM_1 +=thoery, SUM_2 +=reality
SELECT the output (thoery - reality)/reality
Chicken but really want me to this kind of food do really quite troublesome, especially so many companies