Looking to see if someone can help with providing the query which would return a list of technicians (names only) who belong a certain Group. 

For example if the group was called "IT Infrastructure Team", would be looking for a list of Technicians names who are members of that group. 

The Database we are using is MS SQL. 

Many thanks