Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 22 hours ago. Improve this question i want to better query ? SELECT mb1.member_name, mb1.department_id, mb1.member_salary AS max_salary_department FROM member AS mb1 INNER JOIN (SELECT […]