Given the table City:
SELECT Name
FROM City
WHERE CountryCode = ‘USA” OR WHERE CountryCode= ‘JPN’
What does this statement procedure?
A.
A single result set with one column that contains the names of cities from country codes
USA and JPN.
B.
Two result sets each containing a single column with the names of cities from country
codes USA and JPN.
C.
A single result set with two columns containing the names from country codes USA and
JPN.
D.
No result set is returned and an error message is given.
D !!! 2 x where !!!
Result is D if the command is:
SELECT Name FROM City WHERE CountryCode = ‘USA’ OR WHERE CountryCode= ‘JPN’
Result is A if the command is:
SELECT Name FROM City WHERE CountryCode = ‘USA’ OR CountryCode= ‘JPN’
D