Salers.snum Salers.city Orders.odate
SELECT Customers.cname, Salespeople.sname, Salespeople.city FROM Salespeople, Customers WHERE Salespeople.city = Customers.city;
SELECT Orders.odate, Salespeople.sname FROM Orders, Salespeople WHERE Salespeople.snum = Orders.snum;
SELECT sname, cname FROM Salespeople, Customers WHERE sname < cname AND rating < 200;
SELECT onum, cname, Orders.cnum, Orders.snum FROM Salespeople, Customers,Orders WHERE Customers.city < > Salespeople.city AND Orders.cnum = Customers.cnum AND Orders.snum = Salespeople.snum;
SELECT first.cname, second.cname, first.rating FROM Customers first, Customers second WHERE first.rating = second.rating;