Return the maximum value while using JOIN clause

I want to get the subscriber that has maximum value of Bill (Total Bill). I tried using the following script but I didn't not work. Please help me on what I did wrong on this.

  SELECT MAX(B.Total), S.FirstName  FROM Subscriber AS S  JOIN Bill AS B  ON S.MIN=B.MIN   

https://stackoverflow.com/questions/65930053/return-the-maximum-value-while-using-join-clause January 28, 2021 at 10:08AM