w3resource
SQL exercises

SQL Exercises: Prepare a list for which salesman are working for which customer along with city and commissions earned by the salesman.

SQL JOINS: Exercise-3 with Solution

Write a SQL statement to know which salesman are working for which customer.

Sample table: customer


Sample table: salesman


Sample Solution:

SELECT a.cust_name AS "Customer Name", 
a.city, b.name AS "Salesman", b.commission 
FROM customer a 
INNER JOIN salesman b 
ON a.salesman_id=b.salesman_id;

Output of the Query:

Customer Name	city		Salesman	commission
Nick Rimando	New York	James Hoog	0.15
Brad Davis	New York	James Hoog	0.15
Graham Zusi	California	Nail Knite	0.13
Julian Green	London		Nail Knite	0.13
Fabian Johnson	Paris		Mc Lyon		0.14
Geoff Cameron	Berlin		Lauson Hen	0.12
Jozy Altidor	Moscow		Paul Adam	0.13
Brad Guzan	London		Pit Alex	0.11

Explanation:

Syntax of know which salesman are working for which customer

Pictorial presentation :

Result of know which salesman are working for which customer

Query Visualization:

Duration:

Query visualization of Prepare a list for which salesman are working for which customer along with city and commissions earned by the salesman - Duration

Rows:

Query visualization of Prepare a list for which salesman are working for which customer along with city and commissions earned by the salesman - Rows

Cost:

Query visualization of Prepare a list for which salesman are working for which customer along with city and commissions earned by the salesman - Cost

 

Practice Online


Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a SQL statement to make a list with order no, purchase amount, customer name and their cities for those orders which order amount between 500 and 2000.
Next: Write a SQL statement to find the list of customers who appointed a salesman for their jobs who gets a commission from the company is more than 12%.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming