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?

Question

Exhibit

Options

• ASELECT last_name, city FROM members WHERE state ='MO' AND state ='MI';
• BSELECT last_name, city FROM members WHERE state LIKE 'M%';
• CSELECT last_name, city FROM members WHERE state IN ('MO', 'MI');
• DSELECT DISTINCT last_name, city FROM members WHERE state ='MO' OR state

• A
  9% (5)
• B
  5% (3)
• C
  84% (48)
• D
  2% (1)

No community discussion yet for this question.