SQL QUESTION

1. select all the columns from the employees table where the city is allen and the state is SD. +---------+----------+-----------+----------------+-------+-------+-------+ | EMP_NUM | EMP_LAST | EMP_FIRST | ADDRESS | CITY | STATE | ZIP | +---------+----------+-----------+----------------+-------+-------+-------+ | 2 | Smith | Paula | 23 South Lane | Allen | SD | 08262 | | 8 | Chenny | Terry | 12 West Road | Allen | SD | 08932 | | 17 | Holmes | Cora | 17 West Street | Allen | SD | 19836 | +---------+----------+-----------+----------------+-------+-------+-------+ 3 rows in set (0.00 sec)

2. select all the columns from the employees table where city is allen and state is NY. +---------+----------+-----------+----------+-------+-------+-------+ | EMP_NUM | EMP_LAST | EMP_FIRST | ADDRESS | CITY | STATE | ZIP | +---------+----------+-----------+----------+-------+-------+-------+ | 1 | MorriS | Tony | 123 Main | Allen | NY | 23412 | +---------+----------+-----------+----------+-------+-------+-------+ 1 row in set (0.00 sec)

3. select all the columns from employees where city is allen and the employee's last name is smith +---------+----------+-----------+---------------+-------+-------+-------+ | EMP_NUM | EMP_LAST | EMP_FIRST | ADDRESS | CITY | STATE | ZIP | +---------+----------+-----------+---------------+-------+-------+-------+ | 2 | Smith | Paula | 23 South Lane | Allen | SD | 08262 | +---------+----------+-----------+---------------+-------+-------+-------+ 1 row in set (0.00 sec)

4. select all the columns from employees where city is south and the employee's first name is = 'dorra'; +---------+----------+-----------+----------------+-------+-------+-------+ | EMP_NUM | EMP_LAST | EMP_FIRST | ADDRESS | CITY | STATE | ZIP | +---------+----------+-----------+----------------+-------+-------+-------+ | 13 | Smith | Dorra | 102 North Road | South | KY | 42142 | +---------+----------+-----------+----------------+-------+-------+-------+ 1 row in set (0.01 sec)