Question

i) Display the various department numbers from the table Employee. A department numbershould be displayed only once.ii) Display the details of all the employees whose name contain ‘a’ as the second character.iii) Display the highest and the lowest salaries being paid in department 10.iv) display the number of employees working in department 10.v) Display the average age of employees in each department only for those departments inwhich average age is more than 30.

Answer 1

Explanation:

display" (and any subsequent words) was ignored because we limit queries to 32 words.