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

SELECT DISTINCT salesman_id FROM orders;

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