The purpose of this project is to evaluate the financial analysis of the workforce with fake data in an SQL database which includes mocked employee salary and department records. ,The overall goal of ...

, case when x.trns_type = 'Basic' then round(base_salary * (cast(x.percentage as decimal)/100),2) when x.trns_type = 'Allowance' then round(base_salary * (cast(x ...