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?
- SELECT last_name, city FROM members WHERE state ='MO' AND state ='MI';
- SELECT last_name, city FROM members WHERE state LIKE 'M%';
- SELECT last_name, city FROM members WHERE state IN ('MO', 'MI');
- SELECT DISTINCT last_name, city FROM members WHERE state ='MO' OR state ='MI';