From the given table "dept_det" which has columns as "dept_id", "name1", "manger_id", and "location_id". Write a query to retrieve the manager ID of the department where the department ID is 30.Table name:dept_det Input format :The input records are already prepopulated as per the given requirement.

From the given table "emp_det" which has column values "emp_id", "fist_name", "last_name", "email","person_id", "dept_id", "salary". Write a SQL query to retrieve the employee ID, first name, and last name of employees whose first names contain the letter 'S' and who work in departments where at least one employee's first name contains the letter 'S'.Table Name: emp_detInput format :The input records are already prepopulated as per the given requirement.Output format :The result of the query is a list of employee details, including their employee ID, first name, and last name as shown below.emp_id first_name last_name123 S Arvind124 Sj Kumar234 Sk Seema256 Sd venkatRefer to the sample output for the column headers.

Problem StatementWrite a query to retrieve the names and cities of employees who are located either in New York or San Francisco from the Employee table.Table name: EmployeeInput records:Input format :The input table is already created, and records are already prepopulated, as mentioned in the problem statement.Output format :The output displays a list of names and corresponding cities of employees who reside in New York or San Francisco as shown below.name cityMary New YorkEmily New YorkSteven San FranciscoRefer to the sample output for the column headers.Note :The program will be evaluated only after the “Submit Code” is clicked.Extra spaces and new line characters in the program output will result in the failure of the test case.

Problem StatementWrite a query to display the details of employees who are not in the 'Developer' department. Table: EmployeeInput format :The input table is already created, and records are already prepopulated, as mentioned in the problem statement.Output format :The output displays a list of employees who work in departments other than 'Developer' as shown below.id name Department102 Stark HR104 Jack Finance106 Scott AdminRefer to the sample output for the column headers.Note :The program will be evaluated only after the “Submit Code” is clicked.Extra spaces and new line characters in the program output will result in the failure of the test case.

Find the following table EmployeeDetails, with the attributes EmployeeID, EmpName, Designation, Salary, DeptNo. You are assigned to a task of providing the solution to the operations department by writing the query which displays the employeeID and the Designation of all the employees whose Salaries are more than the Salary of employees designated as ManagerC

Assume you have two tables in a database: employees and departments.employees table:employee_id (Primary Key)namedepartment_id (Foreign Key referencing departments.department_id)departments table:department_id (Primary Key)department_nameNow, write an SQL query to retrieve the names of employees along with their corresponding department names.