Question

write a query to find the highest average sales among all the salespersons

Answer 1

Answer:

However, when I try to display a list of the maximum average salary with:

select max (avg(salary)) from (select worker_id, avg(salary) from workers group by worker_id);

it doesn't run. I get an "invalid identifier" error. How do I use the average salary for each worker to find the maximum average for each worker?

Thanks.

I Hope It Will Help!

^_^

Answer 2

select max (avg(salary)) from (select worker_id, avg(salary) from workers group by worker_id);