在MySQL中，从表Persons中选择LastName按字母顺序介于（并包括）Hansen和Pettersen之间的所有列的正确SQL语法是什么？( )
SELECT * FROM Persons WHERE LastName > 'Hansen', LastName < 'Pettersen'
SELECT LastName > 'Hansen' AND LastName < 'Pettersen' FROM Persons
SELECT * FROM persons WHERE LastName > 'Hansen' AND LastName > 'Pettersen'
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
