SELECT * FROM salesman WHERE city IN('Paris','Rome');

SELECT COUNT (DISTINCT salesman_id) FROM orders

SELECT * FROM orders ORDER BY ord_no;

SELECT * FROM orders WHERE salesman_id = (select salesman_id FROM salesman WHERE name='Paul Adam');

SELECT salesman_id "ID", name, 'Salesman' FROM salesman WHERE city='London' UNION (SELECT customer_id "ID", cust_name, 'Customer' FROM customer WHERE city='London')

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;

SELECT * FROM customer WHERE city = 'New York' OR NOT grade>100;