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
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
Pictorial presentation :
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?