Question

which function is used to categorise the data into three or more groups in table.​

Answer 1

Answer:

The COUNT function will count the rows within the subgroup of each group and return the number of employees per department at each location. Apply an ORDER BY clause on the Location column in order to sort the query results in ascending order by location

Explanation:

mark me brainlist and fllw me