Table: football_clubs_value
Columns: rank
team
country
value_m
revenue_m

Question: Name the highest revenue for schalke 04 with rank less than 10
SQL: SELECT MAX("revenue_m") FROM football_clubs_value WHERE "team" = 'schalke 04' AND "rank" < 10

Question: Name the rank for tottenham hotspur
SQL: SELECT "rank" FROM football_clubs_value WHERE "team" = 'tottenham hotspur'

Question: Name the least revenue for chelsea of england with rank less than 7
SQL: SELECT MIN("revenue_m") FROM football_clubs_value WHERE "country" = 'england' AND "team" = 'chelsea' AND "rank" < 7

Question: Name the total number of value for revenue more than 193 and rank less than 12 for manchester united
SQL: SELECT COUNT("value_m") FROM football_clubs_value WHERE "revenue_m" > 193 AND "rank" < 12 AND "team" = 'manchester united'