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 BREB Assistant Programmer February 2025 – Written exam, question 3 of 10.