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