What's wrong with my code?
select Department.Name Department ,Employee.Name Employee, max(Salary) Salary\nfrom  Employee join Department on Employee.DepartmentId = Department.ID \ngroup b
select Department.Name Department ,Employee.Name Employee, max(Salary) Salary\nfrom  Employee join Department on Employee.DepartmentId = Department.ID \ngroup by Department.ID\norder by  Department.ID\n\n{"headers": {"Employee": ["Id", "Name", "Salary", "DepartmentId"], "Department": ["Id", "Name"]}, "rows": {"Employee": [[1, "Joe", 70000, 1], [2, "Henry", 80000, 2], [3, "Sam", 60000, 2], [4, "Max", 90000, 1]], "Department": [[1, "IT"], [2, "Sales"]]}}\n\nmy output: \n{"headers": ["Department", "Employee", "Salary"], "values": [["IT", "Joe", 90000], ["Sales", "Henry", 80000]]}\n\nExpected:\n{"headers": ["Department", "Employee", "Salary"], "values": [["Sales", "Henry", 80000], ["IT", "Max", 90000]]}
[]