1.

Find the average salary and average total remuneration for each job type remember salesman earn commission.

Answer»

SELECT AVG( sal ) , AVG( sal + IFNULL( comm, 0 ) ) FROM emp GROUP BY job;



Discussion

No Comment Found

Related InterviewSolutions