Question

Keshav has written the following query to find out the sum of bonus earned by the employees of WEST zone:

SELECT zone, TOTAL (bonus) FROM employee HAVING zone = 'WEST';

But he got an error. Identify the errors and rewrite the query by underlining the correction(s) done. 

Answer 1

Select Sum(Bonus) from employee where zone = 'WEST';