一个sql语句，包含有几乎所有标准查询语法[2]

                             when ( ( convert(char(8),kmm102.kmm102_over_date,112) < "yyyymmdd" )
                              and kmm102.kmm102_over_status = "00" )
                             then kmm102.kmm102_over_amt else 0 end ),0 ) ) as amt07, 
         sum( isnull( ( select case when ( ( convert(char(8),kmm103.kmm103_pay_date,112) < "yyyymmdd" )
                                     and kmm103.kmm103_pay_status <> "2" )
                                    then kmm103.kmm103_pay_amt else 0 end
                                    from kmm103
                                   where ( kmm103.kmm103_yy = kmm102.kmm102_yy ) 
                                     and ( kmm103.kmm103_bgt_kind = kmm102.kmm102_bgt_kind ) 
                                     and ( kmm103.kmm103_case_no = kmm102.kmm102_case_no ) ),0 ) ) as amt03,  
         sum( isnull( ( select case when ( ( convert(char(8),kmm103.kmm103_pay_date,112) < "yyyymmdd" )
                                     and kmm103.kmm103_pay_status <> "1" )
                                    then kmm103.kmm103_pay_amt else 0 end
                                    from kmm103
                                   where ( kmm103.kmm103_yy = kmm102.kmm102_yy ) 
                                     and ( kmm103.kmm103_bgt_kind = kmm102.kmm102_bgt_kind ) 
                                     and ( kmm103.kmm103_case_no = kmm102.kmm102_case_no ) ),0 ) ) as amt04  
    from kmm102,  
         kmm101 
   where ( kmm102.kmm102_yy = "yyy" ) and
         ( kmm102.kmm102_bgt_kind = "1" ) and
         ( kmm101.kmm101_yy =* kmm102.kmm102_yy ) and
         ( kmm101.kmm101_bgt_kind =* kmm102.kmm102_bgt_kind ) and
         ( kmm101.kmm101_bgt_type =* kmm102.kmm102_bgt_type )
group by substring( kmm102.kmm102_bgt_type,1,4 ), 
         substring( kmm102.kmm102_bgt_type,3,2 ),