Find the id and number of shops for the company that produces the most expensive furniture.
CREATE TABLE furniture (
    furniture_id number,
    name text,
    num_of_component number,
    market_rate number
)

CREATE TABLE manufacturer (
    manufacturer_id number,
    open_year number,
    name text,
    num_of_factories number,
    num_of_shops number
)

CREATE TABLE furniture_manufacte (
    manufacturer_id number,
    furniture_id number,
    price_in_dollar number
)
SELECT t1.manufacturer_id, t1.num_of_shops FROM manufacturer AS t1 JOIN furniture_manufacte AS t2 ON t1.manufacturer_id = t2.manufacturer_id ORDER BY t2.price_in_dollar DESC LIMIT 1
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 id and number of shops for the company that produces the most expensive furniture. ### Input: CREATE TABLE furniture (
    furniture_id number,
    name text,
    num_of_component number,
    market_rate number
)

CREATE TABLE manufacturer (
    manufacturer_id number,
    open_year number,
    name text,
    num_of_factories number,
    num_of_shops number
)

CREATE TABLE furniture_manufacte (
    manufacturer_id number,
    furniture_id number,
    price_in_dollar number
) ### Response: SELECT t1.manufacturer_id, t1.num_of_shops FROM manufacturer AS t1 JOIN furniture_manufacte AS t2 ON t1.manufacturer_id = t2.manufacturer_id ORDER BY t2.price_in_dollar DESC LIMIT 1