Task: Text to Code
Input (English): Show the names of countries and the average speed of roller coasters from each country.
Output (English): SELECT T1.Name ,  avg(T2.Speed) FROM country AS T1 JOIN roller_coaster AS T2 ON T1.Country_ID  =  T2.Country_ID GROUP BY T1.Name