Schema: CREATE TABLE table_name_42 (civil_liberties_2013 VARCHAR, political_rights_2011 VARCHAR, political_rights_2010 VARCHAR, civil_liberties_2012 VARCHAR)
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 table_name_42 WHERE political_rights_2010 = 6 AND civil_liberties_2012 > 5 AND political_rights_2011 < 6