Salary brackets

$2\frac{0}{80}$

$(1)$

How can you analyze the distribution of employee salaries within different departments, specifically identifying the number of employees in low, average. and high salary brackets and calculating the percentage of employees within each bracket for each department?

The salary brackets are defined as follows:

Low Salary: Less than $$5,000.$

Average Salary: Between $$5,000$ and $$7,000,$ inclusive.

High Salary: More than $$7,000.$

we need to round of the percentage of employees up to two decimal places.

order by in the ascending order of the department name

Tables Schema as Below:

$\backslash$table$[[$payments$,],[$columnName$,$dataType$],[$emp$\_$id$,$int$],[$amount$,$decimal $(10,2)$