Select the code of the product that is cheapest in each product category.
CREATE TABLE products (
    code number,
    name text,
    price number,
    manufacturer number
)

CREATE TABLE manufacturers (
    code number,
    name text,
    headquarter text,
    founder text,
    revenue number
)
SELECT code, name, MIN(price) FROM products GROUP BY name
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: Select the code of the product that is cheapest in each product category. ### Input: CREATE TABLE products (
    code number,
    name text,
    price number,
    manufacturer number
)

CREATE TABLE manufacturers (
    code number,
    name text,
    headquarter text,
    founder text,
    revenue number
) ### Response: SELECT code, name, MIN(price) FROM products GROUP BY name