(Solved) : G Print Name Every Department Average Salary Employees Department Department Must Least Tw Q43916804 . . .
(g) Print the name of every department and the average salary of the employees of that department. The department must have at least two employees. (2 points) The answer on the sample database is: dname average Human Resources | 717092.5 Research 490139.6666666667 Hardware 61842.125 dname Software Human Resources Research Hardware Customer Service Business Development budget 1439119 1174402 1544653 4291505 1308515 200000 managerid 110183 110303 110511 111692 111692 NULL emp eid 10042 10059 10073 12000 12010 12020 12030 12100 12110 110183 110303 ename Magy Stamatiou Alejandro McAlpine Shir McClurg Alex Dalas Sergio Ravarez Antonio Lavante Tonny Conner Gladys Cooper Rodney Ferreri Shirish Ossenbruggen Krassimir Wegerle salary 81662 71218 56473 54000 64000 36000 44000 77000 99000 48291 1374402 59 110511 111400 111692 403353 499868 499950 499998 DeForest Hagimont Arie Staelin Tonny Butterworth Shigehito Kropatsch Shaz Bierbaum Weidon Gente Patricia Breugel 48626 72446 40000 59783 61802 54788 40000 did pct_time 100 50 90 works eid 12000 | 12010 12020 | 12030 | 12100 12110 110183 110183 | 110183 110303 100 A တပယတ တ တ တ တ |DU 17 19 | 110303 110511 111400 111692 403353 100 Show transcribed image text (g) Print the name of every department and the average salary of the employees of that department. The department must have at least two employees. (2 points) The answer on the sample database is: dname average Human Resources | 717092.5 Research 490139.6666666667 Hardware 61842.125
dname Software Human Resources Research Hardware Customer Service Business Development budget 1439119 1174402 1544653 4291505 1308515 200000 managerid 110183 110303 110511 111692 111692 NULL emp eid 10042 10059 10073 12000 12010 12020 12030 12100 12110 110183 110303 ename Magy Stamatiou Alejandro McAlpine Shir McClurg Alex Dalas Sergio Ravarez Antonio Lavante Tonny Conner Gladys Cooper Rodney Ferreri Shirish Ossenbruggen Krassimir Wegerle salary 81662 71218 56473 54000 64000 36000 44000 77000 99000 48291 1374402 59 110511 111400 111692 403353 499868 499950 499998 DeForest Hagimont Arie Staelin Tonny Butterworth Shigehito Kropatsch Shaz Bierbaum Weidon Gente Patricia Breugel 48626 72446 40000 59783 61802 54788 40000
did pct_time 100 50 90 works eid 12000 | 12010 12020 | 12030 | 12100 12110 110183 110183 | 110183 110303 100 A တပယတ တ တ တ တ |DU 17 19 | 110303 110511 111400 111692 403353 100
Expert Answer
Answer to (g) Print the name of every department and the average salary of the employees of that department. The department must h…
OR