Table: football_clubs_valuation_2
Columns: rank
team
country
value_m
debt_as_of_value
change_on_year
revenue_m
operating_income_m

Question: What was the average Value ($M) when the Country was England, the Operating income($m) was greater than -5, and the Revenue ($M) was smaller than 103?
SQL: SELECT AVG("value_m") FROM football_clubs_valuation_2 WHERE "country" = 'england' AND "operating_income_m" > -5 AND "revenue_m" < 103

Question: What was the total amount of Value ($M), when the Country was Spain, the Rank was 19, and the Debt as % of value was larger than 159?
SQL: SELECT COUNT("value_m") FROM football_clubs_valuation_2 WHERE "country" = 'spain' AND "rank" = 19 AND "debt_as_of_value" > 159

Question: What was the sum of Value ($M), when the Revenue ($M) was less than 307, the Team was Valencia, and the Rank was smaller than 19?
SQL: SELECT SUM("value_m") FROM football_clubs_valuation_2 WHERE "revenue_m" < 307 AND "team" = 'valencia' AND "rank" < 19

Question: What was the total amount of Value ($M), when the Rank was higher than 6, and the % change on year was -27?
SQL: SELECT COUNT("value_m") FROM football_clubs_valuation_2 WHERE "rank" > 6 AND "change_on_year" = '-27'

Question: What was the sum of Revenue ($M), when the Debt as % of value was higher than 27, and the Operating income($m) was 77?
SQL: SELECT SUM("revenue_m") FROM football_clubs_valuation_2 WHERE "debt_as_of_value" > 27 AND "operating_income_m" = 77