Find the number of funiture types produced by each manufacturer as well as the company names. Visualize by pie chart.
CREATE TABLE furniture_manufacte (
    Manufacturer_ID int,
    Furniture_ID int,
    Price_in_Dollar real
)

CREATE TABLE furniture (
    Furniture_ID int,
    Name text,
    Num_of_Component int,
    Market_Rate real
)

CREATE TABLE manufacturer (
    Manufacturer_ID int,
    Open_Year real,
    Name text,
    Num_of_Factories int,
    Num_of_Shops int
)
SELECT Name, COUNT(*) FROM manufacturer AS t1 JOIN furniture_manufacte AS t2 ON t1.Manufacturer_ID = t2.Manufacturer_ID GROUP BY t1.Manufacturer_ID
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: Find the number of funiture types produced by each manufacturer as well as the company names. Visualize by pie chart. ### Input: CREATE TABLE furniture_manufacte (
    Manufacturer_ID int,
    Furniture_ID int,
    Price_in_Dollar real
)

CREATE TABLE furniture (
    Furniture_ID int,
    Name text,
    Num_of_Component int,
    Market_Rate real
)

CREATE TABLE manufacturer (
    Manufacturer_ID int,
    Open_Year real,
    Name text,
    Num_of_Factories int,
    Num_of_Shops int
) ### Response: SELECT Name, COUNT(*) FROM manufacturer AS t1 JOIN furniture_manufacte AS t2 ON t1.Manufacturer_ID = t2.Manufacturer_ID GROUP BY t1.Manufacturer_ID