How many students are there?
select count ( * ) from student
What are the first names of these students?
select fname from student
Out of these names, which names contain the letter a?
select fname from student where fname like "%a%"