consider employee table of i and list names of


Consider employee table of (i) and list names of department(s) for which average salary for department is more than 10,000.

(SELECT d_name FROM dept
WHERE d_code IN (SELECT d_code
FROM emp GROUP BY d_code
HAVING AVG(sal) ? 10000);

Request for Solution File

Ask an Expert for Answer!!
Database Management System: consider employee table of i and list names of
Reference No:- TGS0282946

Expected delivery within 24 Hours