Who are all the students?
select * from student
What are their first names?
select fname from student
And what about their last names?
select lname from student