select * from employee where lname = 'O'Brien' and st = ''VA''
should be changed to:
select * from employee where lname = ''O'Brien'' and st = ''VA''