Final answer:
To retrieve a student record for a student named 'Peter', use the SQL statement: SELECT * FROM students WHERE name = 'Peter'; ensuring that 'students' is the actual name of your table and 'name' is the column where student names are stored.
Step-by-step explanation:
To find a student record with the name 'Peter', you can use the following SQL statement:
SELECT * FROM students WHERE name = 'Peter';
This SQL statement retrieves all columns of the record from the 'students' table where the name column exactly matches the value 'Peter'. Remember to replace 'students' with the actual name of your table if it's different. This statement assumes that the students table has a column named 'name' where student names are stored. It is also assumed that the name is stored as a case-sensitive text string, which is why 'Peter' is surrounded by single quotes and capitalized exactly as expected.