Comparing Rank vs Grouping to determine Outcome

Good Afternoon Team

Hope all is well.

I am hoping you can help me

Aim : Compare the ranking (Column C) for a given group id (Column B) and populate (Column c) with either ( master , Non Master, or Joint master)

How to define Column C:

Master = Is the rank for a particular group id Higher than the other Rank within the group id
Non Master = Is the rank for a particular group id Lower than the other Rank within the group id
Joint Master = If both ranks for a particular group id are the same

please note that my data set is approx 5000 Rows

I have attached example mock up example