Thanks for this helpful review of the AVG() T-SQL function!
I'd just like to call attention to the few minor typos in the article - just helpful feedback. For example
"all female workers and make workers along with their respective average salary." << should be "male workers"
destination, -- <<< should be designation
WHERE salary > (SELECT AVE(salary) FROM [dbo].[Associates]) -- << should be AVG
As I said, though, these are minor. I compensated for them easily as I followed the article, but I think fixing them will polish the article nicely.