I now have two tables, one table called t_pw_jk check card information table, the table is called a unit information table t_gzdw, I now in addition to query the total number, quantity, on time completion beyond number according to the total number, even number on time, complete the quantity to calculate the percentage, percentage and total number, quantity, on time to complete the quantitative relation on time is as follows: (quantity * number + 1000.0 * 1000.0)/total number/20.0, now I query the total number, quantity, on time to complete the number of SQL has written out, how to write the implementation percentage of SQL want excuse me? Teach bosses,