Can I see a list of students who's first name contains letter "a"?
SELECT DISTINCT Fname FROM STUDENT WHERE Fname LIKE '%a%'
students whose first name contains the letter 'a' refers to Fname LIKE '%a%';