SQL Exercises: Make a list of customers who appointed a salesman for their jobs who gets a commission is above 12%
SQL JOINS: Exercise-4 with Solution
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%.
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 WHERE b.commission>.12;
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 Jozy Altidor Moscow Paul Adam 0.13
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a SQL statement to know which salesman are working for which customer.
Next: Write a SQL statement to find the list of customers who appointed a salesman for their jobs who does not live in the same city where their customer lives, and gets a commission is above 12%.
What is the difficulty level of this exercise?