News:
SELECT * FROM Persons WHERE LastName > 'Hansen', LastName < 'Pettersen'
SELECT LastName > 'Hansen' AND LastName < 'Pettersen' FROM Persons
SELECT * FROM customers WHERE LastName > 'Hansen' AND LastName > 'Pettersen'
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
Useful resources, BETWEEN