SELECT LName FROM STUDENT WHERE Major  =  50
What are the last names of students studying major 50?
SELECT LName FROM STUDENT WHERE Major = 50
select lname from student where major = value
What are the last names of students studying major 50 ?