1) Display the complete list of salespeople table.
2) Display salesperson’s name, city and comm fields.
3) Display odate ,snum , and onum of orders table.
4) Display unique(not allow duplicate)snum from orders table.
5) Display all columns of salespeople whose city is London.
6) Display name, city columns of salespeople whose city is London.
7) Display all columns of customer whose rating is equal to 100.
8) Display all rows from customer table for which salesperson’s number is 1001.
9) Display city, sname, snum, and comm in mentioned order.
10) Write the select command that produces the rating followed by the name of each customer in San Jose.