What select command do I use to Select distinct groups from sql table and at the same time select count total contact numbers for those in each group and display the result in datagridview table?
The result should look like this in the datagridview:

Group | Total Contacts
group1 | 10
group2 | 24
group3 | 14

I know how the select command to use to populate the datagridview without the count but this looks confusing. I don’t know how to start with the select function.

Thank you.