query 2006

[Noshad]

SELECT CPUID, Manufacture, Family, MicroArch, CodeName, ReleaseDate , avg( FP2006 ) , avg( INT2006 ) , Clock, Core

 

FROM (

 

SELECT a.`processor_id` AS CPUID, i.`spec_fp2006_id` , i.`basemean` AS FP2006, b.`spec_int2006_id` , b.`basemean` AS INT2006, f.`name` as Manufacture, g.`name` as Family, h.`name` as MicroArch, j.`name` as CodeName ,  a.`date` as ReleaseDate, a.`clock` as Clock, a.`hw_ncores` as Core

 

FROM `GROUP4_PROCESSOR` a

LEFT JOIN `GROUP4_spec_fp2006` i ON ( a.`processor_id` = i.`processor_id` )

LEFT JOIN `GROUP4_spec_int2006` b ON ( a.`processor_id` = b.`processor_id` )

LEFT JOIN `GROUP4_MANUFACTURER` f ON (a.`manufacturer_id` = f.`manufacturer_id`)

LEFT JOIN `GROUP4_PROCESSOR_FAMILY` g ON (a.`processor_family_id` = g.`processor_family_id`)

LEFT JOIN `GROUP4_MICROARCHITECTURE` h ON (a.`microarchitecture_id` = h.`microarchitecture_id`)

LEFT JOIN `GROUP4_CODE_NAME` j ON (a.`code_name_id` = j.`code_name_id`)

) AS TB1

Where (FP2006 is not Null and INT2006 is not Null and FP2006 !=0 and INT2006!=0)

GROUP BY CPUID