A pie chart showing the proportion of the number of accelerators for each browser.
CREATE TABLE Web_client_accelerator (
    id int,
    name text,
    Operating_system text,
    Client text,
    Connection text
)

CREATE TABLE browser (
    id int,
    name text,
    market_share real
)

CREATE TABLE accelerator_compatible_browser (
    accelerator_id int,
    browser_id int,
    compatible_since_year int
)
SELECT T2.name, COUNT(T2.name) FROM accelerator_compatible_browser AS T1 JOIN browser AS T2 ON T1.browser_id = T2.id JOIN Web_client_accelerator AS T3 ON T1.accelerator_id = T3.id GROUP BY T2.name ORDER BY T1.compatible_since_year DESC
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: A pie chart showing the proportion of the number of accelerators for each browser. ### Input: CREATE TABLE Web_client_accelerator (
    id int,
    name text,
    Operating_system text,
    Client text,
    Connection text
)

CREATE TABLE browser (
    id int,
    name text,
    market_share real
)

CREATE TABLE accelerator_compatible_browser (
    accelerator_id int,
    browser_id int,
    compatible_since_year int
) ### Response: SELECT T2.name, COUNT(T2.name) FROM accelerator_compatible_browser AS T1 JOIN browser AS T2 ON T1.browser_id = T2.id JOIN Web_client_accelerator AS T3 ON T1.accelerator_id = T3.id GROUP BY T2.name ORDER BY T1.compatible_since_year DESC