eid ename esalary email dob1 XYZ 3000.89 [email protected] 1990-08-302 ABC 2300.90 [email protected] 1980-03-211] Write Query to insert 2 Records  in above table using single query.2]Write Query to update esalary to 4000.68 and dob to 1993-08-30  of employee whose eid is 1 in a single query.3] Write Query to delete all records from the table in single query.

Insert Records: Insert 5 records into each table (Vehicles, Trips, and Maintenance).Update Records: Update the Year of a vehicle to 2020 where the Year of the vehicle is 2022.Select Records: Select all records from the Vehicles table to view the current trips.Delete Records: Delete one record from the Trips table based on TripId is 2.Select Records: Select all the records from Trips and Maintenance table

Problem StatementIn a company's Employee Management System, a database table named "Employees" that stores information about employees, including their EmployeeID, EmployeeName, Department, and Salary.The HR department needs a mechanism to delete employee records from the system when an employee leaves the company or for any other valid reason. To address this requirement, you are tasked with creating a stored procedure named "DeleteEmployee," which takes an EmployeeID as input and deletes the corresponding employee record from the "Employees" table.The following table is already created, and the records are inserted into the table.TABLE: Employees EmployeeID INT PRIMARY KEY, EmployeeName VARCHAR(50), Department VARCHAR(50), Salary DECIMAL(10, 2)Prepopulated Records:Input format :The input records are already prepopulated, as given in the problem statement.Output format :The stored procedure deletes the employee record based on the provided EmployeeID.The output should display the employee details after deletion as shown below.EmployeeID EmployeeName Department Salary1 John Doe IT 60000.002 Jane Smith HR 55000.003 Bob Johnson Marketing 70000.004 Alice Williams Finance 80000.00EmployeeID EmployeeName Department Salary1 John Doe IT 60000.003 Bob Johnson Marketing 70000.004 Alice Williams Finance 80000.00Refer to the sample output for the column headers.

Select all the correct answersWrite a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest [email protected]@[email protected] is the primary key column for this table.For example, after running your query, the above Person table should have the following rows:[email protected]@example.comNote: Your output is the whole Person table after executing your sql. Use delete statement.Optionsdelete p.* from Person as p, ( select Email, min(Id) as minId from Person where having count(*) > 1) as q where p.Email = q.Email and Id > q.minId;delete p1 from Person as p1, Person as p2where p1.Email = p2.Email and p1.Id > p2.Id;delete p.* from Person as p, ( select Email, min(Id) as minId from Person group by Email having count(*) > 1) as q where p.Email = q.Email and Id > q.minId;delete p1 from Person as p1, Person as p2where p1.Email != p2.Email and p1.Id <= p2.Id;Finish ClearPrev

Write a query to update the departmentId as "A10" for the details "InformationTechnology" and "E10" for the details "ElectricalElectronicsEngineering" print only the departmentId and details from the department tab

The UNION SQL clause can be used with ____________SELECT clause onlyDELETE and UPDATE clausesUPDATE clause onlyAll of the mentioned