In a fictious world, individuals get taxed depending on how much their company pays their employees. The higher the total salary their companies pay, the less they are taxed.
It's unfair, but that's life.
Write a query to find the salaries of the employees after applying taxes. Round the salary to the nearest integer.
The tax rate is calculated for each individual based on the following criteria:
10% tax if the Sum of all salaries of a company is over 200k.
25% tax if the Sum of all salaries of a company is between 100k -199k
40% tax if the Sum of all salaries of a company is 99k or below.
Include the company id, employee id, department, and the "taxed_salary".