index the vote.voting_session_id column
calculate majority position for each group
meta table: index and constraint
vote.loyal column
calculate and save group majority vote
it's easier to calculate in python