jefflembeck’s Twitter Archive—№ 1,942

SQL ?: Why would SELECT DNAME, COUNT (*) FROM DEPARTMENT, EMPLOYEE WHERE DNUMBER=DNO GROUP BY DNAME HAVING AVG (SALARY) > 30000 show DNUMBER