Database problem--higher than the department average salary query question

Title: Find out the employee's name, salary, department number, and average salary of the department, which is higher than the average salary of the department

1, first find out the average salary of each department

SELECT AVG(salary) pjgz,did FROM man WHERE GROUP BY did

2, as a temporary table, put in the main query

SELECT man.name ,man.salary ,lsb.did ,lsb.pjgz  FROM man ,(SELECT AVG(salary) pjgz,did FROM man GROUP BY did) lsb WHERE man.did =lsb.did  AND man.salary > lsb.pjgz;

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Database problem--higher than the department average salary query question