raning all based on state if tie the hospital name in alphetical order is displayed first via aggregate function