DECLARE @ExampleData TABLE (
	ID INT,
  Name nvarchar(1),
  Type nvarchar(10)
)

INSERT INTO @ExampleData (ID, Name, Type)
  SELECT DISTINCT
	ID,
    Name,
    Type
  FROM (SELECT
  1 AS ID,
    'A' AS Name,
    'coach' AS Type
  UNION ALL
  SELECT
  1,
    'B',
    'coach'
  UNION ALL
  SELECT
	1,
    'C',
    'client'
  UNION ALL
  SELECT
  1,
    'D',
    'client'
  UNION ALL
  SELECT
  2,
    'E',
    'coach'
  UNION ALL
  SELECT
  2,
    'F',
    'client'
  UNION ALL
  SELECT
  2,
    'G',
    'client'
  ) data

/*
View full recordset
*/
SELECT
  e.*
FROM @ExampleData e
ORDER BY e.Name ASC