SQL Exercises: Prepare a list in ascending order for the salesmen who works either for one or more customer or not yet join under any of the customers
SQL JOINS: Exercise-12 with Solution
Write a SQL statement to make a list in ascending order for the salesmen who works either for one or more customer or not yet join under any of the customers.
Sample table: customer
Sample table: salesman
SELECT a.cust_name,a.city,a.grade, b.name AS "Salesman", b.city FROM customer a RIGHT OUTER JOIN salesman b ON b.salesman_id=a.salesman_id ORDER BY b.salesman_id;
Output of the Query:
cust_name city grade Salesman city Brad Davis New York 200 James Hoog New York Nick Rimando New York 100 James Hoog New York Graham Zusi California 200 Nail Knite Paris Julian Green London 300 Nail Knite Paris Geoff Cameron Berlin 100 Lauson Hen San Jose Brad Guzan London Pit Alex London Fabian Johnson Paris 300 Mc Lyon Paris Jozy Altidor Moscow 200 Paul Adam Rome
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a SQL statement to make a report with customer name, city, order number, order date, order amount salesman name and commission to find that either any of the existing customers have placed no order or placed one or more orders by their salesman or by own.
Next: Write a SQL statement to make a list for the salesmen who works either for one or more customer or not yet join under any of the customers who placed either one or more orders or no order to their supplier.
What is the difficulty level of this exercise?