Table: approval_voting_results
Columns: non_dictatorship
pareto_efficiency
majority
monotone
consistency_participation
condorcet
condorcet_loser
clone_independence
reversal_symmetry

Question: What is the majority when the clone independence is no?
SQL: SELECT "majority" FROM approval_voting_results WHERE "clone_independence" = 'no'

Question: what is the consistency & participation when pareto efficiency is yes and condorcet is no?
SQL: SELECT "consistency_participation" FROM approval_voting_results WHERE "pareto_efficiency" = 'yes' AND "condorcet" = 'no'

Question: what is the reversal symmetry when non-dictatorship is yes, consistency & participation is no, and clone independence is yes?
SQL: SELECT "reversal_symmetry" FROM approval_voting_results WHERE "non_dictatorship" = 'yes' AND "consistency_participation" = 'no' AND "clone_independence" = 'yes'

Question: what is the reversal symmetry when non-dicatorship is no and pareto efficiency is no?
SQL: SELECT "reversal_symmetry" FROM approval_voting_results WHERE "non_dictatorship" = 'no' AND "pareto_efficiency" = 'no'

Question: what is the monotone when pareto efficiency is yes, non-dictatorship is yes, and clone independence is yes?
SQL: SELECT "monotone" FROM approval_voting_results WHERE "pareto_efficiency" = 'yes' AND "non_dictatorship" = 'yes' AND "clone_independence" = 'yes'

Question: what is the reversal symmetry when the non-dictatorship is no and condorcet loser is no?
SQL: SELECT "reversal_symmetry" FROM approval_voting_results WHERE "non_dictatorship" = 'no' AND "condorcet_loser" = 'no'