CREATE TABLE table_203_279 (id NUMBER, "interferometer and observing mode" CLOB, "waveband" CLOB, "limiting magnitude" NUMBER, "minimum baseline  ( m ) \ ( un-projected ) " NUMBER, "maximum baseline  ( m ) " NUMBER, "approx. no. visibility measurements per year\ ( measurements per night x nights used per year ) " NUMBER, "max ratio of no. phase / no. amplitude measurements\ ( measure of imaging performance ,  0 = none ) " NUMBER, "accuracy of amplitude2 measurements" CLOB, "accuracy of phase measurements\ ( milli-radians ) " NUMBER, "number of spectral channels\ ( max in use simultaneously ) " CLOB, "comments" CLOB)

which has a limiting magnitude higher than coast visible , chara array or coast infrared ?
SELECT "interferometer and observing mode" FROM table_203_279 WHERE "limiting magnitude" > (SELECT "limiting magnitude" FROM table_203_279 WHERE "interferometer and observing mode" = 'coast visible') AND "interferometer and observing mode" IN ('chara array', 'coast infrared')
SELECT "interferometer and observing mode" FROM "table_203_279" WHERE "interferometer and observing mode" IN ('chara array', 'coast infrared') AND "limiting magnitude" > (SELECT "limiting magnitude" FROM "table_203_279" WHERE "interferometer and observing mode" = 'coast visible')