programming-examples/6. Write a query to display the commission of all the salesmen servicing customers in Paris.sql at master - programming-examples - michuIT: Everything is code

You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

7 lines

237 B

SQL

Raw Permalink Blame History

 /*6. Write a query to display the commission of all the salesmen servicing customers in Paris.*/
 SELECT commission
 FROM salesman
 WHERE salesman_id IN
     (SELECT salesman_id
      FROM customer
      WHERE city = 'Paris');