/*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.*/
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; 