SELECT AVG(Price), Manufacturer FROM Products GROUP BY Manufacturer
Pilih harga rata -rata produk masing -masing pabrikan, hanya menunjukkan kode pabrikan.
CREATE TABLE Products (Manufacturer VARCHAR, Price INTEGER)