<prompt> Kutokana na meza ya mshahara wa wafanyakazi na nguzo EmployeeID, Salary, StartDate, na EndDate, kuandika SQL query cheo wafanyakazi kulingana na mshahara wao ndani ya kila mwaka wamefanya kazi, na 1 kuwa mshahara wa juu kwa kila mwaka.  <response>: Heres a SQL query that should give you the desired result:SELECT EmployeeID, Salary, StartDate, EndDate, DENSE_RANK OVER PARTITION BY EmployeeID, YEARStartDate ORDER BY Salary DESC AS SalaryRank FROM EmployeeSalaries;This query uses the DENSE_RANK window function to assign a salary rank to each employee within each year they have worked. The PARTITION BY clause splits the data into groups by EmployeeID and the year of their StartDate. The ORDER BY clause sorts the salaries in descending order within each group. The result is a table that includes the EmployeeID, Salary, StartDate, EndDate, and SalaryRank columns. 