How many students are there?
select count ( * ) from student
What are their names?
select lname, fname from student
Can I see a list of students who's first name contains letter "a"?
select distinct fname from student where fname like '%a%'