The function of the SQL statement SELECT Student ID, Surname, House Name FROM Student, is that it

The function of the SQL statement SELECT Student ID, Surname, House Name FROM Student, is that it 

Answer Details

The SQL statement SELECT Student ID, Surname, House Name FROM Student is used to retrieve information from the "Student" table in a database. It selects and displays the "Student ID," "Surname," and "House Name" fields/columns for all the rows/records in the "Student" table. Therefore, the correct option is "retrieves the listed fields from student table".