CREATE TABLE table_name_98 (sspec_number VARCHAR2, frequency VARCHAR2)

What is sSpec Number, when Frequency is 1 GHZ?
SELECT sspec_number FROM table_name_98 WHERE frequency = "1 ghz"
SELECT "sspec_number" FROM "table_name_98" WHERE "1 ghz" = "frequency"