💡 Incorporate improved governance action vote totals query

### Area

Voting Pillar

### Is there new design needed?

No

### What?

- this week we worked on a DB-Sync query to count DRep votes
- GovTool currently uses a combination of data from two DB-Sync queries and logic in frontend to calculate vote totals for governance actions, this is not ideal
- we could reuse this new query, to improve how GovTool counts votes

- Please see query
- https://github.com/IntersectMBO/governance-actions/blob/main/ratification-queries/info-ratification.sql

It would be nice to reorganise how GovTool counts votes, so all the logic is in a single query, rather than multiple and frontend logic

### Why?

Putting all the GovTool logic into a single query makes things more maintainable

### How?

best approach TBD

### (Optional) User Story with acceptance criteria

_No response_