select-這段代碼可以改寫成group by...having語句嗎?如果能,怎麼改?

這段代碼可以改寫成group by...having語句嗎?如果能,怎麼改?

SELECT empfname, empsalary FROM qemp
WHERE empsalary <
 (SELECT .90*AVG(empsalary) FROM qemp);

最佳回答：

SELECT empfname, empsalary FROM qemp GROUP BY empsalary HAVING empsalary > 90*AVG(empsalary);