CREATE TABLE table_24018112_1 (cores_threads VARCHAR, max_memory_speed VARCHAR, frequency VARCHAR)

List the number of cores for ddr3-1333 with frequencies between 2.66-2.8ghz.
SELECT cores_threads FROM table_24018112_1 WHERE max_memory_speed = "DDR3-1333" AND frequency = "2.66-2.8GHz"
SELECT "cores_threads" FROM "table_24018112_1" WHERE "2.66-2.8GHz" = "frequency" AND "DDR3-1333" = "max_memory_speed"