CREATE TABLE table_name_87 (name VARCHAR2, rank VARCHAR2, begin_date VARCHAR2)

what name has a Rank of lieutenant colonel, and a Begin Date of 1904-02-22 22 february 1904?
SELECT name FROM table_name_87 WHERE rank = "lieutenant colonel" AND begin_date = "1904-02-22 22 february 1904"
SELECT "name" FROM "table_name_87" WHERE "1904-02-22 22 february 1904" = "begin_date" AND "lieutenant colonel" = "rank"