SELECT LName FROM STUDENT WHERE Major  =  50
Find the last names of students with major 50.
SELECT LName FROM STUDENT WHERE Major = 50
select lname from student where major = value
Find the last names of students with major 50 .