Problem Statement

Assign tax brackets: 'High Tax Bracket' (salary > 100000 AND experience_years > 10), 'Medium Tax Bracket' (salary 70000-100000 inclusive AND experience_years 5-10 inclusive), 'Low Tax Bracket' (salary ≤ 70000), 'Standard' for any combination not matching the three named brackets. Return employee_id, first_name, last_name, salary, experience_years, tax_bracket — ordered by employee_id.

Relevant Tables