Question

Consider the following tables Employee and salary. Write SQL commands for the statements
(i) to (iv)
Table : Employee
Eid Name Deptid Qualification Sex
1 Deepali Gupta 101 MCA F
2 Rajat Tyagi 101 BCA M
3 Hari Mohan 102 B.A M
4 Harry 102 M.A M
5 Sumit Mittal 103 B.Tech M
6 Jyoti 101 M.Tech F
Table : Salary
Eid Basic DA HRA Bonus
1 6000 2000 2300 200
2 2000 300 300 30
3 1000 300 300 40
4 1500 390 490 30
5 8000 900 900 80
6 10000 300 490 89
(i) To display the frequency of employees department wise.
(ii) To list the names of those employees only whose name starts with ‘H’
(iii) To add a new column in salary table . the column name is total_sal.
(iv) To store the corresponding values in the total_sal column.

Answer 1

☝️☝️☝️☝️☝️ this is your answer

hope it's helpful

please mark me brilliance

Answer 2

Answer:

See in top

Explanation:

It was therefore a very 3difficult 2to 222for 2of 22that 2I 3but 2in 33PM 3for 3is 3is 3is 3is 3is 3I 3but 3the 3number is not a problem but mam doesn't have the power to do anything but at