Forum

Forums
SQL
Interview Questions...
Write a query that ...
 
Share:
Notifications
Clear all

Write a query that selects the item name and the name of its seller for each item that belongs to a seller .

 
    Last Post
RSS

Posts: 46
 Deepika Jain
Guest
Topic starter
Jul 30, 2020 2:52 pm
(@Deepika Jain)
Eminent Member
Joined: 5 years ago

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 greater than 4. The query should return the name of the item as the first column and name of the seller as the second column.

Use the below script to create the required table.

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);
This topic was modified 4 years ago by KV Kumar
Topic Tags
item name seller rating grater than 4
1 Reply
Posts: 46
 Manasa P
Guest
Topic starter
Jul 30, 2020 2:58 pm
(@Manasa P)
Eminent Member
Joined: 5 years ago

You can use the below query to get the expected results.

SELECT sellers.name as sellers, items.name as items
FROM items
INNER JOIN sellers ON items.sellerId=sellers.Id
and sellers.rating>4;
This post was modified 4 years ago by KV Kumar
Reply

Leave a reply

Author Name

Author Email

Title *

Preview 0 Revisions Saved
Forum Jump:
  Previous Topic
Next Topic  
Topic Tags:  item name (1) , seller (1) , rating grater than 4 (1) ,
Share: