Table: consistency_criterion
Columns: preferences
1_vs_2
1_vs_3
2_vs_3
total

Question: What is the 1 vs 2 when 2 vs 3 is less than 15 and total is less than 30?
SQL: SELECT COUNT("1_vs_2") FROM consistency_criterion WHERE "2_vs_3" < 15 AND "total" < 30

Question: What is 1 vs 2 when total is more than 28 and 2 vs 3 is 8?
SQL: SELECT "1_vs_2" FROM consistency_criterion WHERE "total" > 28 AND "2_vs_3" = 8

Question: What is the total when 2 vs 3 is less than 15 and 1 vs 3 is 7?
SQL: SELECT COUNT("total") FROM consistency_criterion WHERE "2_vs_3" < 15 AND "1_vs_3" = 7

Question: What is the 2 vs 3 when total is bigger than 38?
SQL: SELECT AVG("2_vs_3") FROM consistency_criterion WHERE "total" > 38

Question: What is the total when preferences is c > b > a and 1 vs 2 is less than 15?
SQL: SELECT MIN("total") FROM consistency_criterion WHERE "preferences" = 'c > b > a' AND "1_vs_2" < 15