Help with SQL query count function

[fluffyvampirekitten]

I want to do a "SUM" of "NO_OF_GROUP" by "INSTITUTION"
How do i write this in sql query statement ?

The image below is an example of my table:





Result:



Thanks in advance!

[orange]

Please show the SQL for your current query attempts.

[NoellaG]

select category, fieldmatched, institution, sum(NO_OF_GROUP) as SumGroups
from [MyTableName]
group by category, fieldmatched, institution

[fluffyvampirekitten]

Please show the SQL for your current query attempts.

SELECT GROUPING.CATEGORY, GROUPING.FIELDMATCHED, GROUPING.INSTITUTION, Count(*) AS NO_OF_GROUP, SummaryDate.Record_Period
FROM (SELECT DISTINCT CATEGORY, GROUP_NO, INSTITUTION, FIELDMATCHED FROM CrossSystemData WHERE INSTITUTION NOT LIKE "*UNKNOWN*")  AS GROUPING, (SELECT Start_Range, End_Range FROM Setting WHERE Type = 'SUMMARY_RANGE')  AS Range, (SELECT Record_Period FROM Summary)  AS SummaryDate
WHERE (((Summary.Record_Period) Between [Range].[Start_Range] And [Range].[End_Range])) AND (((GROUPING.CATEGORY)="POTENTIAL DUP") AND ((GROUPING.FIELDMATCHED)="HIGH"))
GROUP BY GROUPING.CATEGORY, GROUPING.FIELDMATCHED, GROUPING.INSTITUTION, SummaryDate.Record_Period
ORDER BY Count(*) DESC;

[fluffyvampirekitten]

Thanks!