Question

53. The average salary of 120 employees in the bank is
Rs. 15,000 per month. If the no of assistant is thrice the no
of POs and average salary of assistant is 1/3rd of the average
salary of POs then find the average salary of POs ?​

Answer 1

Answer:

We can apply AVG function multiple times in a single SQL statement to calculate the average value of a set of average values. For example, we can use the AVG function to calculate the average salary of employees in each department, and apply the AVG function one more time to calculate the average salary of departments.

Answer 2

Answer is Rs 30000
Refer to attatchment... Hope it help you