Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. SELECT COUNT(sales.Product_id), Salesman_name, quantity
  2. FROM sales, product, salesman
  3. WHERE sales.Product_id=product.Product_id and sales.Salesman_id=salesman.Salesman_id
  4. GROUP BY (sales.Salesman_id)
  5. HAING COUNT (sales.Product_id)>1
  6.  
  7. HAING COUNT(sales.Product_id)>1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement