What are all the distinct student first names?
select distinct fname from student
Of those, which contain the letter "a"?
select distinct fname from student where fname like '%a%'