CREATE TABLE table_name_52 (sspec_number VARCHAR, frequency VARCHAR)

What is the sSpec Number of the model with a 1ghz frequency?
SELECT sspec_number FROM table_name_52 WHERE frequency = "1ghz"
SELECT "sspec_number" FROM "table_name_52" WHERE "1ghz" = "frequency"