CREATE TABLE table_204_300 (id NUMBER, "date from" CLOB, "date to" CLOB, "pos." CLOB, "name" CLOB, "from" CLOB)

name a player whose to date is in march and from date is in january .
SELECT "name" FROM table_204_300 WHERE "date to" = 3 AND "date from" = 1
SELECT "name" FROM "table_204_300" WHERE "date from" = 1 AND "date to" = 3