Table: xeon_specs
Columns: model
speed_ghz
l3_cache_mb
qpi_speed_gt_s
ddr3_clock_mhz
tdp_w
cores
threads
turbo_boost

Question: What is the L3 cache for the processor having a speed of 2.93 GHz?
SQL: SELECT "l3_cache_mb" FROM xeon_specs WHERE "speed_ghz" = '2.93'

Question: How many entries have a speed of exactly 2.53 GHz?
SQL: SELECT COUNT("cores") FROM xeon_specs WHERE "speed_ghz" = '2.53'

Question: What is the speed of the model whose number is W3540?
SQL: SELECT "speed_ghz" FROM xeon_specs WHERE "model" = 'W3540'