Question 33:
Examine the structure of the MEMBERS table.
Which query can be used to display the last names and city names only for members from the states MO and MI?
Answer options:
A. SELECT last_name, city FROM members WHERE state =`MO` AND state =`MI`; B. SELECT last_name, city FROM members WHERE state LIKE `M%`; C. SELECT last_name, city FROM members WHERE state IN (`MO`, `MI`); D. SELECT DISTINCT last_name, city FROM members WHERE state =`MO` OR state =`MI`;