i believe we have to use GROUP BY with AVG(salary), but why not to use it here??. any explanations

Hi Asmaa! The idea is that if you want to obtain the average salaries per manager, you should use the GROUP BY clause, if you want to obtain the average salary for all managers, then you should use only the AVG() aggregate function applied to the salary column like this – AVG(salary). The ROUND() function is used to round the salaries with 2 digits after the decimal point. Hope this helps. Best, Tsvetelin

Follow this topic

Asmaa Abdulhamid

Last answered:

16 Dec 2021

Posted on:

29 Nov 2021

why was GROUP BY function not used with ROUND(AVG(salary)) in solving the task???

in SQL / Using SQL views

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

16 Dec 2021

why was GROUP BY function not used with ROUND(AVG(salary)) in solving the task???

Submit an answer

related questions