SQL Query to find salesmen have more than one customer

Last Post

Posts: 1

Divya

Guest

Topic starter

May 17, 2022 11:11 am

(@Divya)

New Member

Joined: 1 year ago

SQL Query to find salesmen have more than one customer

SELECT salesman_id, COUNT(*) customer_id

FROM
(

SELECT salesman_id, customer_id FROM Salesman_Customers

GROUP BY 1,2

)a

GROUP BY 1

HAVING customer_id > 1

1 Reply

Posts: 18

jeevan 123

May 17, 2022 11:26 am

(@jeevan303500)

Active Member

Joined: 2 years ago

Query and the results attached.

SQL Query to find salesmen have more than one customer.

salesmen-have-more-than-one-customer.jpg