Prev Question
Next Question

Examine the structure of the MEMBERS table.
Name Null? Type
—————- —————– —————————
MEMBER_ID NOT NULL VARCHAR2 (6)
FIRST_NAME VARCHAR2 (50)
LAST_NAME NOT NULL VARCHAR2 (50)
ADDRESS VARCHAR2 (50)
CITY VARCHAR2 (25)
STATE NOT NULL VARCHAR2 (3)
Which query can be used to display the last names and city names only for members from the states MO and
MI?

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’;

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *