TSQL——选择计数较高的行，当计数相同时，选择id值较高的行

HELP!!! I'm stumped and have tried several options to no avail... I need to return one row for each Pub_id, and the row that is returned should be the one with the higher Count and when there is more than one row with the highest count, I need the one with the higher price_id.HELP!!! I'm stumped and have tried several opti