SQL QUESTIONs

13. select all from employees where the state can be wither KY or NY +---------+----------+-----------+-------------------+----------+-------+-------+ | EMP_NUM | EMP_LAST | EMP_FIRST | ADDRESS | CITY | STATE | ZIP | +---------+----------+-----------+-------------------+----------+-------+-------+ | 1 | MorriS | Tony | 123 Main | Allen | NY | 23412 | | 9 | Clark | Hellen | 57th Street | Corneth | NY | 98756 | | 11 | Williams | John | 23rd Front Street | Lane | KY | 45234 | | 12 | Hall | Colleen | 34 West Road | Lane | KY | 45234 | | 13 | Smith | Dorra | 102 North Road | South | KY | 42142 | | 15 | Quinn | Laura | 12 Main Street | Foto | NY | 90832 | | 16 | Rain | Murry | PO BOX 282 | Cake | KY | 49872 | | 18 | Tate | Remus | 293 West Ave | South | KY | 42142 | | 22 | Franks | Tim | 23 Western Lane | Gadzooks | KY | 41832 | | 23 | Dylan | Jane | 11 East Street | Town | KY | 44323 | | 25 | Green | Lenny | 23 Green Valley | Sunny | KY | 43233 | | 27 | Lance | Tim | Route 234 | Town | KY | 44323 | | 28 | Jackson | Dylan | 12 Glass Road | Sol | KY | 49873 | +---------+----------+-----------+-------------------+----------+-------+-------+ 13 rows in set (0.00 sec)

14. select all from employees where the city is town or foto +---------+----------+-----------+----------------+------+-------+-------+ | EMP_NUM | EMP_LAST | EMP_FIRST | ADDRESS | CITY | STATE | ZIP | +---------+----------+-----------+----------------+------+-------+-------+ | 15 | Quinn | Laura | 12 Main Street | Foto | NY | 90832 | | 23 | Dylan | Jane | 11 East Street | Town | KY | 44323 | | 27 | Lance | Tim | Route 234 | Town | KY | 44323 | +---------+----------+-----------+----------------+------+-------+-------+ 3 rows in set (0.00 sec)

15. select all from products where the product name is sofa or the price is more than 50.00 +-------------------+--------+ | PRODUCT_NAME | PRICE | +-------------------+--------+ | Stove | 399.99 | | Mirror | 300.99 | | Shelves | 59.99 | | Gas Range | 599.99 | | Washer | 199.95 | | Dryer | 299.95 | | Sink | 87.99 | | Sofa | 234.95 | | Couch | 495.99 | | 1 GB RAM | 59.95 | | WD 1TB Hard Drive | 100.99 | +-------------------+--------+ 11 rows in set (0.00 sec)

16. select all from products where the product name is stove or price is equal 59.99 +--------------+--------+ | PRODUCT_NAME | PRICE | +--------------+--------+ | Stove | 399.99 | | Shelves | 59.99 | +--------------+--------+ 2 rows in set (0.00 sec)