Return the name and id of the furniture with the highest market rate.
CREATE TABLE furniture_manufacte (
    manufacturer_id number,
    furniture_id number,
    price_in_dollar number
)

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

CREATE TABLE furniture (
    furniture_id number,
    name text,
    num_of_component number,
    market_rate number
)
SELECT name, furniture_id FROM furniture ORDER BY market_rate 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: Return the name and id of the furniture with the highest market rate. ### Input: CREATE TABLE furniture_manufacte (
    manufacturer_id number,
    furniture_id number,
    price_in_dollar number
)

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

CREATE TABLE furniture (
    furniture_id number,
    name text,
    num_of_component number,
    market_rate number
) ### Response: SELECT name, furniture_id FROM furniture ORDER BY market_rate DESC LIMIT 1