Frequency of the aircrafts that has win an award, across by its name as a pie chart
CREATE TABLE pilot (
    Pilot_Id int(11),
    Name varchar(50),
    Age int(11)
)

CREATE TABLE aircraft (
    Aircraft_ID int(11),
    Aircraft varchar(50),
    Description varchar(50),
    Max_Gross_Weight varchar(50),
    Total_disk_area varchar(50),
    Max_disk_Loading varchar(50)
)

CREATE TABLE airport (
    Airport_ID int,
    Airport_Name text,
    Total_Passengers real,
    %_Change_2007 text,
    International_Passengers real,
    Domestic_Passengers real,
    Transit_Passengers real,
    Aircraft_Movements real,
    Freight_Metric_Tonnes real
)

CREATE TABLE airport_aircraft (
    ID int,
    Airport_ID int,
    Aircraft_ID int
)

CREATE TABLE match (
    Round real,
    Location text,
    Country text,
    Date text,
    Fastest_Qualifying text,
    Winning_Pilot text,
    Winning_Aircraft text
)
SELECT Aircraft, COUNT(*) FROM aircraft AS T1 JOIN match AS T2 ON T1.Aircraft_ID = T2.Winning_Aircraft GROUP BY T2.Winning_Aircraft
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: Frequency of the aircrafts that has win an award, across by its name as a pie chart ### Input: CREATE TABLE pilot (
    Pilot_Id int(11),
    Name varchar(50),
    Age int(11)
)

CREATE TABLE aircraft (
    Aircraft_ID int(11),
    Aircraft varchar(50),
    Description varchar(50),
    Max_Gross_Weight varchar(50),
    Total_disk_area varchar(50),
    Max_disk_Loading varchar(50)
)

CREATE TABLE airport (
    Airport_ID int,
    Airport_Name text,
    Total_Passengers real,
    %_Change_2007 text,
    International_Passengers real,
    Domestic_Passengers real,
    Transit_Passengers real,
    Aircraft_Movements real,
    Freight_Metric_Tonnes real
)

CREATE TABLE airport_aircraft (
    ID int,
    Airport_ID int,
    Aircraft_ID int
)

CREATE TABLE match (
    Round real,
    Location text,
    Country text,
    Date text,
    Fastest_Qualifying text,
    Winning_Pilot text,
    Winning_Aircraft text
) ### Response: SELECT Aircraft, COUNT(*) FROM aircraft AS T1 JOIN match AS T2 ON T1.Aircraft_ID = T2.Winning_Aircraft GROUP BY T2.Winning_Aircraft