pls help me SQLInstructions:Answers ALL the questions. This test contributes 5% to your coursework.Use the following Table to write the queries.Emp_Infor TableEmpID EmpFname EmpLname Department Salary1MohdAliHR2000AdminAccount2345AzizahChenAnanthiManjitSulimanKangKulkarniSidhuHRAdminAddressKuantanIpoh18008000DOB01/12/197702/05/197535005000 Kuala Lumpur 01/01/1984Georgetown 02/05/1995Kangar 03/07/19981. Write the query to display all the records in the Emp_Infor table.GenderMFMFM2. Write a query to display the number of employees working in the department'HR'.

Here is the sql query of the above problem. See below steps.

pls help me SQL Instructions: Answers ALL the questions. This test contributes 5% to your coursework. Use the following Table to write the queries. Emp Infor Table EmpID EmpFname EmpLname Department Salary 1 Mohd Ali HR 2000 2 Azizah Suliman Admin 3 Chen Kang Kulkarni 4 Ananthi 5 Manjit Sidhu Address Kuantan 3500 Ipoh 5000 Kuala Lumpur Georgetown Kangar Account HR 1800 Admin 8000 DOB Gender 01/12/1977 M 02/05/1975 01/01/1984 02/05/1995 F 03/07/1998 M 1. Write the query to display all the records in the Emp_Infor table. F M 2. Write a query to display the number of employees working in the department 'HR'.