Given two tables are employee (id, name, salary, dept_id) and department (dept_id, dept_name), write SQL to find MAX salary and average salary of…
Given two tables are employee (id, name, salary, dept_id) and department (dept_id, dept_name), write SQL to find MAX salary and average salary of specific department.
From the DESCO Sub-Assistant Engineer (CSE) 2019 – Written (BUET) exam, question 7 of 10.