SQL Question

17. select all from products where product name is sink and the price is 87.99 or 59.99 +--------------+-------+ | PRODUCT_NAME | PRICE | +--------------+-------+ | Sink | 87.99 | +--------------+-------+ 1 row in set (0.00 sec)

18. select all from students where the last name is smith and the first name is either fred or ben +-----------+----------+-------+-------+ | firstname | lastname | city | state | +-----------+----------+-------+-------+ | Fred | Smith | Here | KY | | Ben | Smith | There | KY | +-----------+----------+-------+-------+ 2 rows in set (0.00 sec)

19. select all from employees where the last name is clack and the state is either KY or OH +---------+----------+-----------+-------------+---------+-------+-------+ | EMP_NUM | EMP_LAST | EMP_FIRST | ADDRESS | CITY | STATE | ZIP | +---------+----------+-----------+-------------+---------+-------+-------+ | 3 | Clark | Jenny | Route 12 | Humming | OH | 23576 | | 9 | Clark | Hellen | 57th Street | Corneth | NY | 98756 | +---------+----------+-----------+-------------+---------+-------+-------+ 2 rows in set (0.00 sec)

20. select all from vendors where credit is equal to 1500.00 or more then 1000.00; +----------+-----------------------+---------+ | VEN_CODE | VEN_NAME | CREDIT | +----------+-----------------------+---------+ | 02 | Easy Out Inc | 2500.00 | | 05 | Jason James Foods | 1500.00 | | 06 | EK Support Inc | 1800.00 | | 07 | George Tate Gym | 1800.00 | | 08 | Up All Night Cleaners | 1600.00 | | 10 | Rosy Market | 1200.00 | +----------+-----------------------+---------+ 6 rows in set (0.00 sec)

21. select all from vendors where credit is 1500.00 or 1800.00 +----------+-------------------+---------+ | VEN_CODE | VEN_NAME | CREDIT | +----------+-------------------+---------+ | 05 | Jason James Foods | 1500.00 | | 06 | EK Support Inc | 1800.00 | | 07 | George Tate Gym | 1800.00 | +----------+-------------------+---------+ 3 rows in set (0.00 sec)

22. select all from vendors where credit is 1500.00 or credit is less than 100.00 +----------+-----------------------+---------+ | VEN_CODE | VEN_NAME | CREDIT | +----------+-----------------------+---------+ | 02 | Easy Out Inc | 2500.00 | | 06 | EK Support Inc | 1800.00 | | 07 | George Tate Gym | 1800.00 | | 08 | Up All Night Cleaners | 1600.00 | +----------+-----------------------+---------+ 4 rows in set (0.00 sec)

23. select all from vendors where the credit is more than 1500.00 or less than 1000.00 +----------+-----------------------+---------+ | VEN_CODE | VEN_NAME | CREDIT | +----------+-----------------------+---------+ | 02 | Easy Out Inc | 2500.00 | | 03 | OK Clothes | 550.00 | | 04 | Spring Cleaners | 750.00 | | 06 | EK Support Inc | 1800.00 | | 07 | George Tate Gym | 1800.00 | | 08 | Up All Night Cleaners | 1600.00 | | 09 | Junky Kars | 125.00 | +----------+-----------------------+---------+ 7 rows in set (0.00 sec)