AND

use OF AND   OR
SELECT NAME   FROM customers   WHERE state = "TX" AND NAME = "Beene"

SELECT NAME   FROM customers   WHERE state = "TX" OR state = "CA"

SELECT NAME   FROM customers   WHERE state = "TX" OR state = "CA"