1) List the name of salesman whose name is of 3 character and second letter is ‘a’.
2) List all the record of salesman whose address is start with ‘a’.
3) List the entire salesman whose pin is grater than 400030.
4) List all the clients whose city’s second letter is ‘a’.
5) List all the clients whose client_no is grater than c00003 and baldue is equal to 0.
6) List name,city,baldue of client whose city start with ‘m’ and baldue is 0.
7) List all the client whose city is Mumbai or state Karnataka.
8) List the product where quantity on hand is grater than 100 and reorderlevel is 50.
9) List all record of product where reorder level is 50 and cost price is grater than 500.
10) List the record of the product where sell price is greater than 500 or cost price is less than 500.
11) List the products where description starts with ‘s’.
12) List all the products whose quantity on hand is between 100 and 200.
13) List all the product where quantity on hand in 200,150,100.
14) List name, city of client where city in Mumbai, Madras.
15) List the product where profit percent between 5 and 10.
16) List the record of the client whose city is not Mumbai.
17) List the record of the client whose city is not Mumbai and state is not Karnataka.
18) List all the record of salesman whose ytdsales is not in 50,100.
19) List all the product whose second character is ‘e’.
20) List all the clients where second character of state is ‘a’.