Correct the following query. Write the correct query and list what was corrected and why. Four corrections to be made.SELECT branch No, COUNT(staffNo) as Total Number of Staff, ADD(salary)FROM StaffORDER BY branch NoGROUP BY branch No;

Question 3You have two technicians who each have been assigned an employee_id. The technicians are responsible for performing service calls for customers. The service calls are recorded in the servicecalls table. When a record is created in the servicecalls table, the employee_id is recorded in the servicecalls table.You are creating a query to count the number of service calls performed by each technician. You want the output of the query to look like this:Employee_idCount(call_id)34921402817157You begin creating the query:SELECT employee_id, count(call_id) FROM servicecalls _____________ employee_idWhat should you type in the blank space? (Please type your answer all in upper case. Example: SELECT or UNION ALL)

What will be the output of the following SQL statement: "SELECT COUNT(*) FROM Employees WHERE Salary > 50000"?It will return the total salary paid to the employees who earn more than 50000It will return the average salary of the employees who earn more than 50000It will return the number of employees who earn more than 50000None of the above

Raj, a Database Administrator, needs to display the average pay of workersfrom those departments which have more than five employees. He isexperiencing a problem while running the following query:SELECT DEPT, AVG(SAL) FROM EMP WHERE COUNT(*) > 5GROUP BY DEPT;Which of the following is a correct query to perform the given task?i. SELECT DEPT, AVG(SAL) FROM EMP WHERE COUNT(*) > 5GROUP BY DEPT;ii. SELECT DEPT, AVG(SAL) FROM EMP HAVING COUNT(*) >5 GROUP BY DEPT;iii. SELECT DEPT, AVG(SAL) FROM EMP GROUP BY DEPTWHERE COUNT(*) > 5;iv. SELECT DEPT, AVG(SAL) FROM EMP GROUP BY DEPTHAVING COUNT(*) > 5;

What SQL query is used to count the number of employees in each department? SELECT COUNT(*) FROM Employees GROUP BY Department;SELECT COUNT(*) AS TotalEmployees FROM Employees GROUP BY Department;SELECT COUNT(DISTINCT Department) FROM Employees;SELECT COUNT(Department) FROM Employees GROUP BY Department;

Write a query to display the number of  the buildings who has given the fine amount.Give an alias name as 'building_count'.Note:1. Display only the number of buildings from the building table who has given the fine_amount. Use subqueries to achieve this.2. Tables involved are building, meter and bill.3. Specify the alias name without any mistake.4. Compare your executed result with the sample output given below.Note:1. Display only the number of  the buildings who has given the fine amount from bill table.2. Specify the alias name without any mistake.3. Compare your executed result with the sample output given below.