Get all Items attached to sellerId - SQL
<p>When execute my query i just get 1 item back that i attached to the sellerId instead of 2. Does anyone know how i can say?</p>

<p>select the name of item and re seller for each item that belongs to the re seller. With a rating higher than 4?</p>

<p>Current Query:</p>

<pre><code>SELECT items.name, sellers.name
FROM items
inner JOIN sellers
on items.id=sellers.id
WHERE rating &gt; 4
ORDER BY sellerId
</code></pre>

<p>The query for tables inc. data:</p>

<pre><code>CREATE TABLE sellers (
  id INTEGER NOT NULL PRIMARY KEY,
  name VARCHAR(30) NOT NULL,
  rating INTEGER NOT NULL
);

CREATE TABLE items (
  id INTEGER NOT NULL PRIMARY KEY,
  name VARCHAR(30) NOT NULL,
  sellerId INTEGER REFERENCES sellers(id)
);

INSERT INTO sellers(id, name, rating) values(1, 'Roger', 3);
INSERT INTO sellers(id, name, rating) values(2, 'Penny', 5);

INSERT INTO items(id, name, sellerId) values(1, 'Notebook', 2);
INSERT INTO items(id, name, sellerId) values(2, 'Stapler', 1);
INSERT INTO items(id, name, sellerId) values(3, 'Pencil', 2);
</code></pre>