Which of the following SQL statements will select the fields name and address from the contacts table?
A.
SELECT (name, address) FROM contacts;
B.
SELECT (name address) FROM contacts;
C.
SELECT name, address FROM contacts;
D.
SELECT name address FROM contacts;
Explanation:
see http://www.sqlite.org/syntaxdiagrams.html#select-stmt for a detailed description of the SQL select syntax.