How to Group data In Sql Server Query

Question

select cf.Name as FromName, tf.NoOfGoalFrom,ct.Name as ToName,tt.NoOfGoalTo from TournamentCurrentStatus t

inner JOIN TournamentCurrentStatusFrom tf on t.TournamentCurrentStatusFromID=tf.TournamentCurrentStatusFromID

inner JOIN TournamentCurrentStatusTo tt on t.TournamentCurrentStatusToID=tt.TournamentCurrentStatusToID

inner JOIN Club as cf on tf.ClubIDFrom=cf.ClubID

inner JOIN Club as ct on tt.ClubIDTo=ct.ClubID

 

 

 

How to group like Kdma-10 Both Goals Grouping with team name