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

Question

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 COUNT(EmpNo)
FROM EMPLOYEE;
D)SELECT HireDate,COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000;
E)SELECT HireDate,COUNT(*)
FROM EMPLOYEE
GROUP BY HireDate;

Quizplus · Accepted Answer

The command in option D is not valid because it uses an aggregate function (COUNT) without a GROUP BY clause for the non-aggregated column (HireDate).

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