SQL Query: Find department name and average salary from 2 tables, Department and Employee. Department table Department(dept_id, dept_name) Employee…

SQL Query: Find department name and average salary from 2 tables, Department and Employee.

Department table

Department(dept_id, dept_name)

Employee table

Employee(emp_id, emp_name, salary, dept_id)

From the Islami Bank Engineer March 2025 – Written (BUET) exam, question 7 of 7.

More from this paper