Task: Text to Code
Input (English): How many leagues are there in England?
Output (English): SELECT count(*) FROM Country AS T1 JOIN League AS T2 ON T1.id  =  T2.country_id WHERE T1.name  =  "England"