In MySQL

1. select all the columns from the employees table where the city is allen and the state is SD.

2. select all the columns from the employees table where city is allen and state is NY.

3. select all the columns from employees where city is allen and the employee's last name is smith

4. select all the columns from employees where city is south and the employee's first name is = 'dorra';

5. select * from employees where city is lane and employee last name is hall;

6. select all from employees where city is cake and employee last name is rain

7. select all from students where city is here and state is ky

8. select all from students where city is there and state is ky

9. select all from students where city is somewhere and state is ky

10. select all from students where the first name is jill and the city is somewhere

11. select all from vendors where the vendor code is 02 and the credit is 2500.00

12. select all from employees where the state can be either SD or NY

13. select all from employees where the state can be wither KY or NY

14. select all from employees where the city is town or foto

15. select all from products where the product name is sofa or the price is more than 50.00

16. select all from products where the product name is stove or price is equal 59.99

17. select all from products where product name is sink and the price is 87.99 or 59.99

18. select all from students where the last name is smith and the first name is either fred or ben

19. select all from employees where the last name is clack and the state is either KY or OH

20. select all from vendors where credit is equal to 1500.00 or more then 1000.00;

21. select all from vendors where credit is 1500.00 or 1800.00

22. select all from vendors where credit is 1500.00 or credit is less than 100.00

23. select all from vendors where the credit is more than 1500.00 or less than 1000.00