SELECT count(*),status_id,status_name FROM kcrt_statuses WHERE STATUS_ID IN (SELECT STATUS_ID FROM kcrt_request_type_statuses) GROUP BY status_id; What will be the output?
Returns the count of rows grouped by statuses
Error - Incorrect use of COUNT. It has to have a column name.
Error - because of the GROUP BY Clause or Selected columns
Does not return the count, just displays the other two fields.