postgresql-9.5

In my Postgresql database, the Student table has student_marks and total_marks columns. I want to get the percentage based on student marks. For example: student_marks * 100 / total_marks => 118 * 100 / 147 = 80.27 = 80% If the first two digits of decimal number are below 50, ex: 75.49 then it should be 75% or if the first …