--create a table
CREATE TABLE Fabricantes (
  code INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  price TEXT NOT NULL
);

-- create a table
CREATE TABLE Articulos (
  code INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  price TEXT NOT NULL,
  fabricantes NOT NULL
);
-- insert some values
INSERT INTO Articulos VALUES (152, "Fideos", 1200,3);
INSERT INTO Articulos VALUES (156, "Arroz", 1600,2);
INSERT INTO Articulos VALUES (161, "Aceite", 2300, 2);
INSERT INTO Articulos VALUES (616, "Atún", 2000, 5);
    -- fetch some values

SELECT AVG (price), fabricantes
FROM Articulos 
GROUP BY fabricantes;