select查询语句的优化问题

Question

不知道因为VB+SQLITESPY+DATAGRID的脆弱性，还是其他原因，明明在sqlitespy中正常运行的，在VB+SQLITESPY+DATAGRID提示无法运行了，所以，我在想，应该可能是代码问题，能否对下面代码进行优化，谢谢。

SELECT
    s.school_running_type as '学校类型',s.organization_name as '学校名称',s.organization_no as '学校代码',
    SUM(CASE WHEN S.b IN ('4.0','5.0','6.0','7.0') AND S.FLAG ='1' THEN S.c ELSE  0 END ) AS '小学大专及以上学历',
    SUM(CASE WHEN S.b IN ('4.0','5.0') AND S.FLAG ='1' THEN S.c ELSE 0 END) '研究生',
    SUM(CASE WHEN S.b IN ('6.0') AND S.FLAG ='1' THEN S.c ELSE 0 END) '本科',
    SUM(CASE WHEN S.b IN ('7.0') AND S.FLAG ='1' THEN S.c ELSE 0 END) '专科',
    SUM(CASE WHEN S.b IN ('5.0','6.0','7.0') AND S.FLAG ='2' THEN S.c ELSE  0 END ) AS '中学本科及以上学历',
    SUM(CASE WHEN S.b IN ('6.0','5.0') AND S.FLAG ='2' THEN S.c ELSE 0 END) '研究生',
    SUM(CASE WHEN S.b IN ('7.0') AND S.FLAG ='2' THEN S.c ELSE 0 END) '本科'  
FROM
    (SELECT '1' FLAG,  a.school_running_type,a.organization_name ,a.organization_no , a.b,a,c  FROM  教基4155 A
        UNION
     SELECT '2' FLAG,  a.school_running_type,a.organization_name ,a.organization_no , a.b,a,c   FROM 教基4156 A
    )S
    GROUP BY  s.school_running_type ,s.organization_name,s.organization_no 
    having s.school_running_type<>'幼儿园'

```

Answer 1

是这个吧，需要优化