Completed
Incomplete
Not Attended
Share
You have been hired as a database administrator for an Indian company that tracks all employee information. The company wants to ensure that the employee records are updated efficiently, and that all queries return accurate results. Your job is to manage the employee records and assist with different updates and queries
Question - 1The HR department wants to know how many employees are currently registered. Can you provide this information?
Question - 2Anil Kumar has recently been promoted to Senior Designer with a salary increase to 65000. Can you update his information?
Question - 3Pooja Verma has left the company. Can you help remove her record from the employee database and display all remaining employees?
Question - 4The company wants to know the total salary being paid to all employees. Can you help provide this information?
Question - 5A new employee, Rakesh Iyer, has joined the Marketing department as an Intern with a salary of 35000. Can you add his record?
Code Editor
Table Name: employees
| id | name | position | salary | department |
|---|---|---|---|---|
| 1 | Rajesh Sharma | Manager | 85000.00 | HR |
| 2 | Pooja Verma | Developer | 60000.00 | IT |
| 3 | Anil Kumar | Designer | 50000.00 | Marketing |
>>> Submit Your Query to validate