CREATE TABLE table_name_2 (type VARCHAR2, scratch VARCHAR2)

What type has a scratch of 750 GB?
SELECT type FROM table_name_2 WHERE scratch = "750 gb"
SELECT "type" FROM "table_name_2" WHERE "750 gb" = "scratch"