Given a Table with the Structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the Following

Multiple Choice

Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate) ,which of the following is not a valid ANSI SQL command?

A) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'Ja%';
B) SELECT COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000;
C) SELECT HireDate,COUNT(*)
FROM EMPLOYEE
GROUP BY HireDate;
D) SELECT HireDate,COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000;