What SQL statement do we use to display the record of all students whose last name contains 5 letters ending with "A"?

1. SELECT * FROM STUDENTS WHERE LNAME LIKE '_ _ _ _A';
2. SELECT * FROM STUDENTS WHERE LNAME LIKE '_ _ _ _';
3. SELECT * FROM STUDENTS WHERE LNAME LIKE '????A';
4. SELECT * FROM STUDENTS WHERE LNAME LIKE '*A';

Which one of the following is not an aggregate function ?

1. ROUND()
2. SUM()
3. COUNT()
4. AVG()

Consider a table named Employees with columns — EName, Age, Salary and Designation. Which SQL statement do we use to find out the total salary given to employees?

1. Select SUM(Salary) From Employees;
2. Select COUNT (*) From Employees;
3. Select FIND (*) From Employees;
4. Select SUM () From Employees;

Which clause in SQL is used to apply a condition on a group?

1. Where
2. Having
3. As
4. On