Challenge: Data Manipulation

Problem statement

There’s a table named Employee that contains the information of the employees. It has the following columns.

• empid: This is the primary key of the table.
• empname: This column contains the employee’s name.
• salary: This column contains the employee’s salary.
• city: This column contains the city of the employee.