CREATE TABLE table_48942 ("Buffalo" CLOB, "Rochester" CLOB, "Syracuse" CLOB, "Utica" CLOB, "Albany" CLOB)

What is Syracuse, when Buffalo is Oatka Creek Shale, and when Albany is Berne?
SELECT "Syracuse" FROM table_48942 WHERE "Buffalo" = 'oatka creek shale' AND "Albany" = 'berne'
SELECT "Syracuse" FROM "table_48942" WHERE "Albany" = 'berne' AND "Buffalo" = 'oatka creek shale'