Question: how to calculate tax percentage in sql query?
Answer: We can write the following query to perform this calculation: SELECT (COUNT(IF (percentage_marks >= 80, 1, NULL))/COUNT(*))*100 as percentage_student_gr_80_in_finance FROM (SELECT A. student_name, sum(A. marks_subject)*100/sum(B.