SQL Question

9. select all from students where city is somewhere and state is ky +-----------+----------+-----------+-------+ | firstname | lastname | city | state | +-----------+----------+-----------+-------+ | Jill | Smith | Somewhere | KY | +-----------+----------+-----------+-------+ 1 row in set (0.00 sec)

10. select all from students where the first name is jill and the city is somewhere +-----------+----------+-----------+-------+ | firstname | lastname | city | state | +-----------+----------+-----------+-------+ | Jill | Smith | Somewhere | KY | +-----------+----------+-----------+-------+ 1 row in set (0.00 sec)

11. select all from vendors where the vendor code is 02 and the credit is 2500.00 +----------+--------------+---------+ | VEN_CODE | VEN_NAME | CREDIT | +----------+--------------+---------+ | 02 | Easy Out Inc | 2500.00 | +----------+--------------+---------+ 1 row in set (0.00 sec)

12. select all from employees where the state can be either SD or NY +---------+----------+-----------+----------------+---------+-------+-------+ | EMP_NUM | EMP_LAST | EMP_FIRST | ADDRESS | CITY | STATE | ZIP | +---------+----------+-----------+----------------+---------+-------+-------+ | 1 | MorriS | Tony | 123 Main | Allen | NY | 23412 | | 2 | Smith | Paula | 23 South Lane | Allen | SD | 08262 | | 8 | Chenny | Terry | 12 West Road | Allen | SD | 08932 | | 9 | Clark | Hellen | 57th Street | Corneth | NY | 98756 | | 14 | Bennet | June | 12 South Road | Kidd | SD | 08332 | | 15 | Quinn | Laura | 12 Main Street | Foto | NY | 90832 | | 17 | Holmes | Cora | 17 West Street | Allen | SD | 19836 | +---------+----------+-----------+----------------+---------+-------+-------+ 7 rows in set (0.00 sec)