求一分类汇总SQL的写法
一个表中有 5个字段 写一句SQL实现 新增加一列 品种3 根据 集約型名分类并将N值汇总
品種 PKG 集約型名 AT区分 N
MSIG M51132FP CF0G 016P2N A/T 10
MSIG M51132FP DF0G 016P2N A/T 2
MSIG M51132FP TF0G 016P2N A/T 1
MSIG M61508FP DF0G 036P2R A/T 0
MSIG M61510AFP DF0G 042P2R A/T 7
MSIG M61516FP RF0G 080P6N A/T 0
MSIG M61523FP DF0G 024P2Q A/T 4
POWER M54514AFP 200D 016P2N A/T 0
POWER M54514AFP DB0J 016P2N A/T 0
POWER M54523FP DB0J 016P2N A/T 6
POWER M54566FP DB0J 016P2N A/T 96
POWER M54566FP DB1J 016P2N A/T 30
POWER M54567FP DB1J 016P2N A/T 112
MCU M34280E1GP D00G 020P2F A/T 1.9
MCU M34280M1-XXXGP D00G 020P2F A/T 0
MCU M34280M1-XXXGP U00G 020P2F A/T 0
MCU M34280M1-XXXGP W40G 020P2F A/T 22.5
MCU M34282E2GP U00G 020P2F A/T 8
MCU M34282M1-XXXGP T40G 020P2F A/T 0
MCU M34282M1-XXXGP U00G 020P2F A/T 8.889
MCU M34282M1-XXXGP W40G 020P2F A/T 430
MCU M34282M2-XXXGP U00G 020P2F A/T 114.545
MCU M34282M2-XXXGP W40G 020P2F A/T 442.14
MCU M34580M2-XXXFP U10G 020P2N A/T 6.138
MCU M34580M2-XXXFP W30G 020P2N A/T 52
MCU M34580M4-XXXFP D00G 020P2N A/T 0.051
MCU M34580M4-XXXFP W30G 020P2N A/T 72
MCU M35017-XXXFP D00G 020P2Q A/T 0
MCU M35041-XXXFP W30G 020P2Q A/T 4
MCU M35055-XXXFP W40G 020P2Q A/T 1
MCU R5F21194DD U00G 020P4B A/T 0
MCU R5F211A1DD U00G 020P4B A/T 0.2
MCU R5F211A1XXXDD U00G 020P4B A/T 0
MCU M30624MGA-XXXFP D00G 100P6S A/T 0
MCU M30624MGA-XXXFP U00G 100P6S A/T 2.193
MCU M30624MGA-XXXFP U30G 100P6S A/T 0
品种3 判定标准 备注
QZROM : ??????G ,R5R*
TINY : R5F* 020P2F
MASK : 其他
------------------------------------
FB : ??????G , R*
MASK: 其他 其他