CREATE TABLE table_3890 ("Model - Computer name" CLOB, "CPU type" CLOB, "No. of processors" CLOB, "Period of operation" CLOB, "Maximum peak performance  (  Teraflops  ) " CLOB, "Use" CLOB)

Name the use for amd opteron dual-core 2.6ghz
SELECT "Use" FROM table_3890 WHERE "CPU type" = 'AMD Opteron dual-core 2.6GHz'
SELECT "Use" FROM "table_3890" WHERE "CPU type" = 'AMD Opteron dual-core 2.6GHz'