WebShop


SQL Joins Public

Easy  

7min

Each item in a web shop belongs to a different seller. To ensure service quality, each seller has a rating.

The data are kept in the following two tables:

TABLE sellers
  id INTEGER PRIMARY KEY,
  name VARCHAR(30) NOT NULL,
  rating INTEGER NOT NULL

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

Write a query that selects the item name and the name of its seller for each item that belongs to a seller with a rating of more than 4.

See the example case for more details.

SQLite 3.9.2
   

  •   Example case: Wrong answer
  •   Single seller with single item: Wrong answer
  •   Top rated sellers: Wrong answer
  •   Various sellers: Wrong answer