I have a table in SQL server with data of Courses, WorkingArea and Province and I want to get the count of WorkingArea for each Province and for each course.

Could you help me please?

For example, there are 2 "Desempleados" in "Almeria" for "Course A", so I want "2" as result in another column, but when I try to group by, the results are never ok…

The result should be:

>Solution :

You use a GROUP BY clause. The GROUP BY clause is used within a SELECT statement to group rows into sets based on the values of one or more columns. It is often used with aggregate functions such as SUM, AVG, MAX, MIN, and COUNT to calculate summary information for each group. e.g.

SELECT
      coursename
    , workingarea
    , province
    , count(*) AS cnt
FROM your_table
GROUP BY
      coursename
    , workingarea
    , province