Table: middle_east_democracy
Columns: country
political_rights_2010
civil_liberties_2010
status_2010
political_rights_2011
civil_liberties_2011
status_2011
political_rights_2012
civil_liberties_2012
status_2012
political_rights_2013
civil_liberties_2013
status_2013

Question: How many civil liberties 2013 values are associated with a 2010 political rights value of 6, civil liberties 2012 values over 5, and political rights 2011 under 6?
SQL: SELECT COUNT("civil_liberties_2013") FROM middle_east_democracy WHERE "political_rights_2010" = 6 AND "civil_liberties_2012" > 5 AND "political_rights_2011" < 6

Question: What is the average 2012 civil liberties value associated with a 2011 status of not free, political rights 2012 over 6, and political rights 2011 over 7?
SQL: SELECT AVG("civil_liberties_2012") FROM middle_east_democracy WHERE "status_2011" = 'not free' AND "political_rights_2012" > 6 AND "political_rights_2011" > 7

Question: What is the total number of civil liberties 2011 values having 2010 political rights values under 3 and 2011 political rights values under 1?
SQL: SELECT COUNT("civil_liberties_2011") FROM middle_east_democracy WHERE "political_rights_2010" < 3 AND "political_rights_2011" < 1