Question

12) Consider following schema Employee (E_id, E_name, Salary, Department) Write SQL commands for following statement.

i. Find Summation of salary for all employees.
ii. Display Minimum and Maximum Salary.
iii. Display all record in descending order of Employee name.
iv. Display employee name working in department “Quality




`\:`

Don't Spam ∼
Thank uh!:)​

Answer 1

`\underline{ \textsf \purple{ \: Employee table : - \: }}`

━━━━━━━━━━━━━━━━━━━━━━━

i ]

`\textsf \color{green}{↪ select sum salary from Employee;}`

`\:`

`\:`

━━━━━━━━━━━━━━━━━━━━━━━

ii ]

`\underline{ \textsf \color{brown}{ \: For maximum salary: \: }}`

`\textsf \blue{↪ select max( salary ) from Employee;}`

`\:`

━━━━━━━━━━━━━━━━━━━━━━━

`\:`

`\underline{ \textsf \color{hotpink}{ \:For minimum salary : \: }}`

`\textsf \orange{↪select min( salary ) from Employee;}`

`\:`

━━━━━━━━━━━━━━━━━━━━━━━

iii ]

`\:`

━━━━━━━━━━━━━━━━━━━━━━━

iv ]

`\:`

`\:`

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

hope it helps ⸙