What SQL statement do we use to print out the record of all students whose last name

Q. What SQL statement do we use to print out the record of all students whose last name starts with L?

(a) SELECT * FROM EXAM_RESULTS WHERE LNAME LIKE ‘L%’ ;

(b) SELECT * FROM EXAM_RESULTS WHERE LNAME LIKE 'L' ;

(c) SELECT * FROM EXAM_RESULTS WHERE LNAME = 'L' ;

(d) SELECT * FROM EXAM_RESULTS WHERE LNAME <> 'L' ;

Consider  this table --

You can understand by seeing this video ---

Answer =

(a) SELECT * FROM EXAM_RESULTS WHERE LNAME LIKE ‘L%’ ;