A  B  C  D  E 1  IDENTICATION NUMBER  BASIC SALARY (N)  TOTAL ALLOWANCE (N)  TOTAL DEDUCTION (N)  NET SALARY (N) 2  WASC/LPT/001  800000  60000  40000  820000 3  WASC/LPT/002  700000  40000  20000  720000 4  WASC/LPT/003  300000  10000  5000  305000 5  WASC/LPT/004  400000  20000  10000  410000 Figure 3What formula will calculate the total number of individuals who earn less than ₦500,000 from the table as shown in Figure 3?A. =COUNT(E2:E5,B. =COUNT(E2:E5)C. =COUNTA(E2:E5)D. =COUNTIF(E2:E5,

A  B  C  D  E 1  IDENTICATION NUMBER  BASIC SALARY (N)  TOTAL ALLOWANCE (N)  TOTAL DEDUCTION (N)  NET SALARY (N) 2  WASC/LPT/001  800000  60000  40000  820000 3  WASC/LPT/002  700000  40000  20000  720000 4  WASC/LPT/003  300000  10000  5000  305000 5  WASC/LPT/004  400000  20000  10000  410000Figure 3What formula will correctly display the total number of individuals involved in the computation as shown in Figure 3?A. =COUNT(A2:A5)B. =COUNTIF(A2:A5)C. =COUNTA(A2:A5)D. =SUM(A2:A5)

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

Shyam works at a company where his gross salary is calculated based on his basic salary along with other allowances. The company provides him with a Dearness Allowance (DA) of 10% and a Travel Allowance (TA) of 12%. Given Shayam's basic salary, write a program to calculate his gross salary. Note: This question was asked in Wipro coding test.Input format :The input consists of an integer N, representing Shyam's basic salary.Output format :The output prints "Gross Salary = " followed by an integer representing Shyam's gross salary.Refer to the sample output for formatting specifications.Code constraints :1000 ≤ N ≤ 50000Sample test cases :Input 1 :1280Output 1 :Gross Salary = 1561Input 2 :35750Output 2 :Gross Salary = 43615Input 3 :50000Output 3 :Gross Salary = 61000Note :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.

What will the following code generate?df = df[ (df['income'] <= 2000) ]df['income'].sum()A.Select employees who make less than $2,000.B.Select employees who make less than or equal to $2,000, and then sum up all their salaries.C.Select employees who make more than $2,000.D.Select employees who make more than or equal to $2,000, and then sum up all their salaries.

Problem StatementFin is managing salary taxation and wants a program to determine the net salaries based on the provided salary amount. Determine the net salary: If the salary is less than 50000, print "No Tax." For salaries between 50000 (inclusive) and 100000 (exclusive), apply 10% tax and print the net salary after deduction.For 100000 or more, apply 20% tax and print the net salary after deduction.Implement a program that takes Fin's salary as input (integer) and calculates the net salary after converting it into float.Input format :The input consists of an integer value n, representing Fin's monthly salary.Output format :If no tax is applicable, the output prints "No Tax"If a tax is applicable, the output prints "Salary after X% Tax: Y" where X represents the applicable tax percent value and Y represents the net salary after deduction with two decimal places.Refer to the sample output for the formatting specifications.Code constraints :In this scenario, the test cases fall under the following constraints:1000 ≤ n ≤ 120000Sample test cases :Input 1 :40000Output 1 :No TaxInput 2 :60000Output 2 :Salary after 10% Tax: 54000.00Input 3 :120000Output 3 :Salary after 20% Tax: 96000