Given a table salary, such as the one below, that has m=male and f=femalevalues. Swap all f and m values (i.e., change all f values to m and vice versa)with a single update statement and no intermediate temp table.Note : You must write a single update statement, DO NOT write any selectstatement for this problem.Example:idnamesexsalary1Am25002Bf15003Cm55004Df500After running your update statement, the above salary table should have thefollowing rows:idnamesexsalary1Af25002Bm15003Cf55004Dm500Optionsupdate salaryset sex = if(sex = 'm', 'f', 'm');update salaryset sex = if(sex = 'm', 'm', 'm');update nameset salary = if(name = 'm', 'f', 'm');update salaryset sex = if(sex != 'f', 'm', 'm');

In PostgreSQL, create a PL/pgSQL block that defines a procedure namedupdate_employee_salary which takes two parameters: employee_id and new_salary. This procedure should update the salary ofthe employee with the given employee_id to the new salary value. Assume “employee” table with fields – eid, ename and salary

Consider a database table called "Employees" with the following columns:  EmployeeID (integer)  Name (text)  Age (integer)  Department (text)Sample data:What is the SQL query to update the age of the employee with EmployeeID 3 to 29?OptionsUPDATE Employees SET Age = 29 WHERE EmployeeID = 3;UPDATE Employees SET Age = 29;UPDATE Employees SET Age = 29 WHERE Name = 'Mike Davis';UPDATE Employees SET Age = 29 WHERE Age = 28;

Problem StatementCreate a query to update the membercost column to 1000 in the facilities table where the value of monthlymaintenance is greater than 500.The column names and data types are given below.

reate PL/pgSQL procedure for the increment of employees where in salary less than 35000 will get hike of 15% in their previoussalary and other will get 10% hike in their previous salary. Using following schema, Employees (id, name, department, salary)call the procedure by id and print employee’s name with their updated salary

Problem statementSend feedbackSuppose you have a list of employees in a company, and each employee is represented as an object with the following properties:"id" - a unique identifier for the employee"name" - the employee's name"department" - the department the employee works in"salary" - the employee's current salaryObjectives:You want to make a modification to the list of employees to reflect a recent company-wide salary increase. You have been provided with the following information:Salaries for employees in the "sales" department should be increased by 10%.Salaries for employees in the "engineering" department should be increased by 15%.Salaries for employees in all other departments should be increased by 5%.You need to write a function "increaseSalaries" that takes an array of employee objects and returns a new array of employee objects where each employee's salary has been updated based on their department. The original array of employees should be left unchanged.