Which of the following SQL statements will select the fields name and address from the contacts table?

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. Reference: https://www.sqltutorial.org/sql-select/

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