sujal KhatiwadaPro Student 291 Points
SQL Practice Problem
There are 267 employees and 15 with last names starting with 'A'. What does this return?
SELECT COUNT(1) FROM EMPLOYEES GROUP BY 'A';
The GROUP BY isn't doing anything because there is not a valid table value to group by. So the number of employees gets counted, which is 267.
To count the last names beginning with 'A' the code would look something like this:
SELECT COUNT(1) FROM EMPLOYEES WHERE EMPLOYEES.LAST_NAME LIKE 'A%'