SQL question

5. select * from employees where city is lane and employee last name is hall; +---------+----------+-----------+--------------+------+-------+-------+ | EMP_NUM | EMP_LAST | EMP_FIRST | ADDRESS | CITY | STATE | ZIP | +---------+----------+-----------+--------------+------+-------+-------+ | 12 | Hall | Colleen | 34 West Road | Lane | KY | 45234 | +---------+----------+-----------+--------------+------+-------+-------+ 1 row in set (0.00 sec)

6. select all from employees where city is cake and employee last name is rain +---------+----------+-----------+------------+------+-------+-------+ | EMP_NUM | EMP_LAST | EMP_FIRST | ADDRESS | CITY | STATE | ZIP | +---------+----------+-----------+------------+------+-------+-------+ | 16 | Rain | Murry | PO BOX 282 | Cake | KY | 49872 | +---------+----------+-----------+------------+------+-------+-------+ 1 row in set (0.00 sec)

7. select all from students where city is here and state is ky | firstname | lastname | city | state | +-----------+----------+------+-------+ | Fred | Smith | Here | KY | | Ted | Smith | Here | KY | +-----------+----------+------+-------+ 2 rows in set (0.00 sec)

8. select all from students where city is there and state is ky +-----------+----------+-------+-------+ | firstname | lastname | city | state | +-----------+----------+-------+-------+ | Ben | Smith | There | KY | +-----------+----------+-------+-------+ 1 row in set (0.00 sec)