Database questions-higher than the average department salary query problem, the average department salary

Database questions-higher than the average department salary query problem, the average department salary
Question: find out the name, salary, Department number, and average salary of the employee higher than the average salary of the Department

1. First, find the average salary of each department

Select avg (salary) pjgz, did FROM man where group by did

2. Use it as a temporary table and place it in the primary 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 Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.