Question

Write SQL statements for the following questions.
1. Show details of employees working in ‘testing’ department.
2. Show details of Male employees working in organisation.
3. Show total salary of Female employees.
4. Show dept and salary of employees having alphabets ‘a’ twice in name.
5. Sort the table on salary in descending order.

Answer 1

Explanation:

(b) Answer the following questions briefly in your own words.(i) What was Professor Plumb's newly invented form of food?(ii) What was lying under the thimble?(iii) Why did the father raise his voice in benediction?