SQL Subquery Exercises: Display the names and numbers of all salesmen who had more than one customer

SQL SUBQUERY: Exercise-11 with Solution

11. From the following tables write a SQL query to find salespeople who had more than one customer. Return salesman_id and name.

Sample table: customer

Sample table: salesman

Sample Solution:

SELECT salesman_id,name 
FROM salesman a 
WHERE 1 < 
    (SELECT COUNT(*) 
     FROM customer 
     WHERE salesman_id=a.salesman_id);

Output of the Query:

salesman_id	name
5001		James Hoog
5002		Nail Knite

Explanation:

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Contribute your code and comments through Disqus.

Previous: From the following tables, write a SQL query to find the customers whose orders issued on 17th August, 2012. Return ord_no, purch_amt, ord_date, customer_id, salesman_id and cust_name.
Next: From the following tables, write a SQL query to find those orders, which are higher than average amount of the orders. Return ord_no, purch_amt, ord_date, customer_id and salesman_id.