SELECT T_AssetInfos_ID, MAX(T_AssetConstruct_Name), MAX(T_AssetProperties_Name), SUM(CAST(PropertyValue AS INT)) FROM T_AssetPropertyData WHERE T_AssetConstruct_Name IN ('硬盘', '内存条') GROUP BY T_AssetInfos_ID, T_AssetConstruct_ID, T_AssetProperties_ID