We have Entrance Exam Data of students in a class

We want the following columns to be added:

IF Exam Score > 70, Passed. Otherwise, Did Not Pass

IF Student Passed and Interview Superstar is Yes, Accept. Otherwise, No

Fees per year = 4000 for Economics, 3000 for Finance and 2500 for Banking

Total Fee collected = (Fee per year) * (Study Term ) * Payment Ratio. Where Payment Ratio is 1 for Payment Status of Regular, 0.5 for Semi Scholarship, 0 for Scholarship, 0.9 for Finance Support