CREATE TABLE table_name_18 (purpose VARCHAR2, band VARCHAR2, frequency VARCHAR2)

Band of am, and a Frequency of 0 846 has what purpose?
SELECT purpose FROM table_name_18 WHERE band = "am" AND frequency = "0 846"
SELECT "purpose" FROM "table_name_18" WHERE "0 846" = "frequency" AND "am" = "band"