Table: yorkfield_processors
Columns: processor
brand_name
model_list
cores
l2_cache
socket
tdp

Question: what is the model where the processor is yorkfield and the brand name is xeon?
SQL: SELECT "model_list" FROM yorkfield_processors WHERE "processor" = 'Yorkfield' AND "brand_name" = 'Xeon'

Question: what is the socket that has a brand name of core 2 extreme?
SQL: SELECT "socket" FROM yorkfield_processors WHERE "brand_name" = 'Core 2 Extreme'

Question: what is the name of the processor for model x33x0?
SQL: SELECT "processor" FROM yorkfield_processors WHERE "model_list" = 'X33x0'