Which of the following SQL statements will select the fields name and address from the...

The correct syntax for selecting specific columns from a table in SQL is to use the SELECT keyword followed by a comma-separated list of column names and then the FROM keyword followed by the table name. Therefore, the only option that follows this syntax is C. SELECT name, address FROM contacts; The other options are incorrect because they either use parentheses around the column names, which are not needed, or they omit the comma between the column names, which causes a syntax error. References: https://www.sqltutorial.org/sql-select/

https://www.w3schools.com/mysql/mysql_select.asp