SELECT PERSON.IO_PERS AS ФИО, PERSON.S_N AS Паспорт, 
                PERSON.DT_DOC AS [Дата выдачи], PERSON.GIVEN AS [Кем выдан],
                PERSON.ADDRESS AS Адрес, Query1.num_stoc1 AS [Акций 1 и 2 вып],
                Sum(L_SCH.NUM_STOC) AS [Всего акций],
               "имеет акции 1 и 2 вып" AS Примечание
FROM L_SCH, PERSON, 
               (SELECT L_SCH.DEPO_SCH, SUM(L_SCH.NUM_STOC) AS num_stoc1
                FROM SERT_VIP, L_SCH
                WHERE SERT_VIP.REG_N LIKE "*08-1-412*" AND
                                SERT_VIP.N_VIP=L_SCH.N_VIP 
                 GROUP BY L_SCH.DEPO_SCH
                 HAVING  COUNT(L_SCH.DEPO_SCH)=2
                 ORDER BY L_SCH.DEPO_SCH) AS Query1
WHERE  L_SCH.DEPO_SCH= Query1.DEPO_SCH  AND
               PERSON.DEPO_SCH=Query1.DEPO_SCH
GROUP BY PERSON.IO_PERS, PERSON.S_N, PERSON.DT_DOC, PERSON.GIVEN,
                     PERSON.ADDRESS, Query1.num_stoc1
ORDER BY PERSON.IO_PERS;