Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --SQL FIRST QUERY
- SELECT DISTINCT items.name,sellers.name
- FROM items INNER JOIN sellers ON items.sellerid=sellers.id
- WHERE sellers.rating>4;
- --SECOND QUERY
- SELECT sellers.name
- FROM items INNER JOIN sellers ON items.sellerid=sellers.id
- WHERE (SELECT AVG(price)
- FROM items
- WHERE items.sellerid=sellers.id)>10
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement