w3resource
SQL exercises

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


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 
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

Explanation:

Syntax of Make a list of customers who appointed a salesman for their jobs who gets a commission  is above 12%

Pictorial presentation:

Make a list of customers who appointed a salesman for their jobs who gets a commission  is above 12%

Query Visualization:

Duration:

Query visualization of Make a list of customers who appointed a salesman for their jobs who gets a commission is above 12% - Duration

Rows:

Query visualization of Make a list of customers who appointed a salesman for their jobs who gets a commission is above 12% - Rows

Cost:

Query visualization of Make a list of customers who appointed a salesman for their jobs who gets a commission is above 12% - Cost

 

Practice Online


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?



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