Show the names of countries and the average speed of roller coasters from each country by a pie chart.
CREATE TABLE country (
    Country_ID int,
    Name text,
    Population int,
    Area int,
    Languages text
)

CREATE TABLE roller_coaster (
    Roller_Coaster_ID int,
    Name text,
    Park text,
    Country_ID int,
    Length real,
    Height real,
    Speed text,
    Opened text,
    Status text
)
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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show the names of countries and the average speed of roller coasters from each country by a pie chart. ### Input: CREATE TABLE country (
    Country_ID int,
    Name text,
    Population int,
    Area int,
    Languages text
)

CREATE TABLE roller_coaster (
    Roller_Coaster_ID int,
    Name text,
    Park text,
    Country_ID int,
    Length real,
    Height real,
    Speed text,
    Opened text,
    Status text
) ### Response: 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