Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

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

### Question ###
which has a limiting magnitude higher than coast visible , chara array or coast infrared ?

### Accurate SQL ###

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')