SELECT -- + 03 SUM(y."Z03-AA") AS "Z03-AA", SUM(y."Z03-BB") AS "Z03-BB", SUM(y."Z03-CC") AS "Z03-CC", SUM(y."Z03-11") AS "Z03-11", SUM(y."Z03-12") AS "Z03-12", SUM(y."Z03-21") AS "Z03-21", SUM(y."Z03-22") AS "Z03-22", SUM(y."Z03-31") AS "Z03-31", SUM(y."Z03-32") AS "Z03-32", SUM(y."Z03-41") AS "Z03-41", SUM(y."Z03-42") AS "Z03-42", SUM(y."Z03-51") AS "Z03-51", SUM(y."Z03-52") AS "Z03-52", SUM(y."Z03-61") AS "Z03-61", SUM(y."Z03-62") AS "Z03-62", SUM(y."Z03-71") AS "Z03-71", SUM(y."Z03-72") AS "Z03-72", SUM(y."Z03-81") AS "Z03-81", SUM(y."Z03-82") AS "Z03-82", SUM(y."Z03-91") AS "Z03-91", SUM(y."Z03-92") AS "Z03-92", SUM(y."Z03-A1") AS "Z03-A1", SUM(y."Z03-A2") AS "Z03-A2", SUM(y."Z03-B1") AS "Z03-B1", SUM(y."Z03-B2") AS "Z03-B2", SUM(y."Z03-C1") AS "Z03-C1", SUM(y."Z03-C2") AS "Z03-C2", SUM(y."Z03-D1") AS "Z03-D1", SUM(y."Z03-D2") AS "Z03-D2", -- + 04 SUM(y."Z04-AA") AS "Z04-AA", SUM(y."Z04-BB") AS "Z04-BB", SUM(y."Z04-CC") AS "Z04-CC", SUM(y."Z04-11") AS "Z04-11", SUM(y."Z04-12") AS "Z04-12", SUM(y."Z04-21") AS "Z04-21", SUM(y."Z04-22") AS "Z04-22", SUM(y."Z04-31") AS "Z04-31", SUM(y."Z04-32") AS "Z04-32", SUM(y."Z04-41") AS "Z04-41", SUM(y."Z04-42") AS "Z04-42", SUM(y."Z04-51") AS "Z04-51", SUM(y."Z04-52") AS "Z04-52", SUM(y."Z04-61") AS "Z04-61", SUM(y."Z04-62") AS "Z04-62", SUM(y."Z04-71") AS "Z04-71", SUM(y."Z04-72") AS "Z04-72", SUM(y."Z04-81") AS "Z04-81", SUM(y."Z04-82") AS "Z04-82", SUM(y."Z04-91") AS "Z04-91", SUM(y."Z04-92") AS "Z04-92", SUM(y."Z04-A1") AS "Z04-A1", SUM(y."Z04-A2") AS "Z04-A2", SUM(y."Z04-B1") AS "Z04-B1", SUM(y."Z04-B2") AS "Z04-B2", SUM(y."Z04-C1") AS "Z04-C1", SUM(y."Z04-C2") AS "Z04-C2", SUM(y."Z04-D1") AS "Z04-D1", SUM(y."Z04-D2") AS "Z04-D2", -- + 06 SUM(y."Z06-AA") AS "Z06-AA", SUM(y."Z06-BB") AS "Z06-BB", SUM(y."Z06-CC") AS "Z06-CC", SUM(y."Z06-11") AS "Z06-11", SUM(y."Z06-12") AS "Z06-12", SUM(y."Z06-21") AS "Z06-21", SUM(y."Z06-22") AS "Z06-22", SUM(y."Z06-31") AS "Z06-31", SUM(y."Z06-32") AS "Z06-32", SUM(y."Z06-41") AS "Z06-41", SUM(y."Z06-42") AS "Z06-42", SUM(y."Z06-51") AS "Z06-51", SUM(y."Z06-52") AS "Z06-52", SUM(y."Z06-61") AS "Z06-61", SUM(y."Z06-62") AS "Z06-62", SUM(y."Z06-71") AS "Z06-71", SUM(y."Z06-72") AS "Z06-72", SUM(y."Z06-81") AS "Z06-81", SUM(y."Z06-82") AS "Z06-82", SUM(y."Z06-91") AS "Z06-91", SUM(y."Z06-92") AS "Z06-92", SUM(y."Z06-A1") AS "Z06-A1", SUM(y."Z06-A2") AS "Z06-A2", SUM(y."Z06-B1") AS "Z06-B1", SUM(y."Z06-B2") AS "Z06-B2", SUM(y."Z06-C1") AS "Z06-C1", SUM(y."Z06-C2") AS "Z06-C2", SUM(y."Z06-D1") AS "Z06-D1", SUM(y."Z06-D2") AS "Z06-D2", -- + 07 SUM(y."Z07-AA") AS "Z07-AA", SUM(y."Z07-BB") AS "Z07-BB", SUM(y."Z07-CC") AS "Z07-CC", SUM(y."Z07-11") AS "Z07-11", SUM(y."Z07-12") AS "Z07-12", SUM(y."Z07-21") AS "Z07-21", SUM(y."Z07-22") AS "Z07-22", SUM(y."Z07-31") AS "Z07-31", SUM(y."Z07-32") AS "Z07-32", SUM(y."Z07-41") AS "Z07-41", SUM(y."Z07-42") AS "Z07-42", SUM(y."Z07-51") AS "Z07-51", SUM(y."Z07-52") AS "Z07-52", SUM(y."Z07-61") AS "Z07-61", SUM(y."Z07-62") AS "Z07-62", SUM(y."Z07-71") AS "Z07-71", SUM(y."Z07-72") AS "Z07-72", SUM(y."Z07-81") AS "Z07-81", SUM(y."Z07-82") AS "Z07-82", SUM(y."Z07-91") AS "Z07-91", SUM(y."Z07-92") AS "Z07-92", SUM(y."Z07-A1") AS "Z07-A1", SUM(y."Z07-A2") AS "Z07-A2", SUM(y."Z07-B1") AS "Z07-B1", SUM(y."Z07-B2") AS "Z07-B2", SUM(y."Z07-C1") AS "Z07-C1", SUM(y."Z07-C2") AS "Z07-C2", SUM(y."Z07-D1") AS "Z07-D1", SUM(y."Z07-D2") AS "Z07-D2", -- + 08 SUM(y."Z08-AA") AS "Z08-AA", SUM(y."Z08-BB") AS "Z08-BB", SUM(y."Z08-CC") AS "Z08-CC", SUM(y."Z08-11") AS "Z08-11", SUM(y."Z08-12") AS "Z08-12", SUM(y."Z08-21") AS "Z08-21", SUM(y."Z08-22") AS "Z08-22", SUM(y."Z08-31") AS "Z08-31", SUM(y."Z08-32") AS "Z08-32", SUM(y."Z08-41") AS "Z08-41", SUM(y."Z08-42") AS "Z08-42", SUM(y."Z08-51") AS "Z08-51", SUM(y."Z08-52") AS "Z08-52", SUM(y."Z08-61") AS "Z08-61", SUM(y."Z08-62") AS "Z08-62", SUM(y."Z08-71") AS "Z08-71", SUM(y."Z08-72") AS "Z08-72", SUM(y."Z08-81") AS "Z08-81", SUM(y."Z08-82") AS "Z08-82", SUM(y."Z08-91") AS "Z08-91", SUM(y."Z08-92") AS "Z08-92", SUM(y."Z08-A1") AS "Z08-A1", SUM(y."Z08-A2") AS "Z08-A2", SUM(y."Z08-B1") AS "Z08-B1", SUM(y."Z08-B2") AS "Z08-B2", SUM(y."Z08-C1") AS "Z08-C1", SUM(y."Z08-C2") AS "Z08-C2", SUM(y."Z08-D1") AS "Z08-D1", SUM(y."Z08-D2") AS "Z08-D2", -- + 09 SUM(y."Z09-AA") AS "Z09-AA", SUM(y."Z09-BB") AS "Z09-BB", SUM(y."Z09-CC") AS "Z09-CC", SUM(y."Z09-11") AS "Z09-11", SUM(y."Z09-12") AS "Z09-12", SUM(y."Z09-21") AS "Z09-21", SUM(y."Z09-22") AS "Z09-22", SUM(y."Z09-31") AS "Z09-31", SUM(y."Z09-32") AS "Z09-32", SUM(y."Z09-41") AS "Z09-41", SUM(y."Z09-42") AS "Z09-42", SUM(y."Z09-51") AS "Z09-51", SUM(y."Z09-52") AS "Z09-52", SUM(y."Z09-61") AS "Z09-61", SUM(y."Z09-62") AS "Z09-62", SUM(y."Z09-71") AS "Z09-71", SUM(y."Z09-72") AS "Z09-72", SUM(y."Z09-81") AS "Z09-81", SUM(y."Z09-82") AS "Z09-82", SUM(y."Z09-91") AS "Z09-91", SUM(y."Z09-92") AS "Z09-92", SUM(y."Z09-A1") AS "Z09-A1", SUM(y."Z09-A2") AS "Z09-A2", SUM(y."Z09-B1") AS "Z09-B1", SUM(y."Z09-B2") AS "Z09-B2", SUM(y."Z09-C1") AS "Z09-C1", SUM(y."Z09-C2") AS "Z09-C2", SUM(y."Z09-D1") AS "Z09-D1", SUM(y."Z09-D2") AS "Z09-D2", -- + 10 SUM(y."Z10-AA") AS "Z10-AA", SUM(y."Z10-BB") AS "Z10-BB", SUM(y."Z10-CC") AS "Z10-CC", SUM(y."Z10-11") AS "Z10-11", SUM(y."Z10-12") AS "Z10-12", SUM(y."Z10-21") AS "Z10-21", SUM(y."Z10-22") AS "Z10-22", SUM(y."Z10-31") AS "Z10-31", SUM(y."Z10-32") AS "Z10-32", SUM(y."Z10-41") AS "Z10-41", SUM(y."Z10-42") AS "Z10-42", SUM(y."Z10-51") AS "Z10-51", SUM(y."Z10-52") AS "Z10-52", SUM(y."Z10-61") AS "Z10-61", SUM(y."Z10-62") AS "Z10-62", SUM(y."Z10-71") AS "Z10-71", SUM(y."Z10-72") AS "Z10-72", SUM(y."Z10-81") AS "Z10-81", SUM(y."Z10-82") AS "Z10-82", SUM(y."Z10-91") AS "Z10-91", SUM(y."Z10-92") AS "Z10-92", SUM(y."Z10-A1") AS "Z10-A1", SUM(y."Z10-A2") AS "Z10-A2", SUM(y."Z10-B1") AS "Z10-B1", SUM(y."Z10-B2") AS "Z10-B2", SUM(y."Z10-C1") AS "Z10-C1", SUM(y."Z10-C2") AS "Z10-C2", SUM(y."Z10-D1") AS "Z10-D1", SUM(y."Z10-D2") AS "Z10-D2", -- + 11 SUM(y."Z11-AA") AS "Z11-AA", SUM(y."Z11-BB") AS "Z11-BB", SUM(y."Z11-CC") AS "Z11-CC", SUM(y."Z11-11") AS "Z11-11", SUM(y."Z11-12") AS "Z11-12", SUM(y."Z11-21") AS "Z11-21", SUM(y."Z11-22") AS "Z11-22", SUM(y."Z11-31") AS "Z11-31", SUM(y."Z11-32") AS "Z11-32", SUM(y."Z11-41") AS "Z11-41", SUM(y."Z11-42") AS "Z11-42", SUM(y."Z11-51") AS "Z11-51", SUM(y."Z11-52") AS "Z11-52", SUM(y."Z11-61") AS "Z11-61", SUM(y."Z11-62") AS "Z11-62", SUM(y."Z11-71") AS "Z11-71", SUM(y."Z11-72") AS "Z11-72", SUM(y."Z11-81") AS "Z11-81", SUM(y."Z11-82") AS "Z11-82", SUM(y."Z11-91") AS "Z11-91", SUM(y."Z11-92") AS "Z11-92", SUM(y."Z11-A1") AS "Z11-A1", SUM(y."Z11-A2") AS "Z11-A2", SUM(y."Z11-B1") AS "Z11-B1", SUM(y."Z11-B2") AS "Z11-B2", SUM(y."Z11-C1") AS "Z11-C1", SUM(y."Z11-C2") AS "Z11-C2", SUM(y."Z11-D1") AS "Z11-D1", SUM(y."Z11-D2") AS "Z11-D2", -- + 16 SUM(y."Z16-AA") AS "Z16-AA", SUM(y."Z16-BB") AS "Z16-BB", SUM(y."Z16-CC") AS "Z16-CC", SUM(y."Z16-11") AS "Z16-11", SUM(y."Z16-12") AS "Z16-12", SUM(y."Z16-21") AS "Z16-21", SUM(y."Z16-22") AS "Z16-22", SUM(y."Z16-31") AS "Z16-31", SUM(y."Z16-32") AS "Z16-32", SUM(y."Z16-41") AS "Z16-41", SUM(y."Z16-42") AS "Z16-42", SUM(y."Z16-51") AS "Z16-51", SUM(y."Z16-52") AS "Z16-52", SUM(y."Z16-61") AS "Z16-61", SUM(y."Z16-62") AS "Z16-62", SUM(y."Z16-71") AS "Z16-71", SUM(y."Z16-72") AS "Z16-72", SUM(y."Z16-81") AS "Z16-81", SUM(y."Z16-82") AS "Z16-82", SUM(y."Z16-91") AS "Z16-91", SUM(y."Z16-92") AS "Z16-92", SUM(y."Z16-A1") AS "Z16-A1", SUM(y."Z16-A2") AS "Z16-A2", SUM(y."Z16-B1") AS "Z16-B1", SUM(y."Z16-B2") AS "Z16-B2", SUM(y."Z16-C1") AS "Z16-C1", SUM(y."Z16-C2") AS "Z16-C2", SUM(y."Z16-D1") AS "Z16-D1", SUM(y."Z16-D2") AS "Z16-D2", -- + 17 SUM(y."Z17-AA") AS "Z17-AA", SUM(y."Z17-BB") AS "Z17-BB", SUM(y."Z17-CC") AS "Z17-CC", SUM(y."Z17-11") AS "Z17-11", SUM(y."Z17-12") AS "Z17-12", SUM(y."Z17-21") AS "Z17-21", SUM(y."Z17-22") AS "Z17-22", SUM(y."Z17-31") AS "Z17-31", SUM(y."Z17-32") AS "Z17-32", SUM(y."Z17-41") AS "Z17-41", SUM(y."Z17-42") AS "Z17-42", SUM(y."Z17-51") AS "Z17-51", SUM(y."Z17-52") AS "Z17-52", SUM(y."Z17-61") AS "Z17-61", SUM(y."Z17-62") AS "Z17-62", SUM(y."Z17-71") AS "Z17-71", SUM(y."Z17-72") AS "Z17-72", SUM(y."Z17-81") AS "Z17-81", SUM(y."Z17-82") AS "Z17-82", SUM(y."Z17-91") AS "Z17-91", SUM(y."Z17-92") AS "Z17-92", SUM(y."Z17-A1") AS "Z17-A1", SUM(y."Z17-A2") AS "Z17-A2", SUM(y."Z17-B1") AS "Z17-B1", SUM(y."Z17-B2") AS "Z17-B2", SUM(y."Z17-C1") AS "Z17-C1", SUM(y."Z17-C2") AS "Z17-C2", SUM(y."Z17-D1") AS "Z17-D1", SUM(y."Z17-D2") AS "Z17-D2", -- + 18 SUM(y."Z18-AA") AS "Z18-AA", SUM(y."Z18-BB") AS "Z18-BB", SUM(y."Z18-CC") AS "Z18-CC", SUM(y."Z18-11") AS "Z18-11", SUM(y."Z18-12") AS "Z18-12", SUM(y."Z18-21") AS "Z18-21", SUM(y."Z18-22") AS "Z18-22", SUM(y."Z18-31") AS "Z18-31", SUM(y."Z18-32") AS "Z18-32", SUM(y."Z18-41") AS "Z18-41", SUM(y."Z18-42") AS "Z18-42", SUM(y."Z18-51") AS "Z18-51", SUM(y."Z18-52") AS "Z18-52", SUM(y."Z18-61") AS "Z18-61", SUM(y."Z18-62") AS "Z18-62", SUM(y."Z18-71") AS "Z18-71", SUM(y."Z18-72") AS "Z18-72", SUM(y."Z18-81") AS "Z18-81", SUM(y."Z18-82") AS "Z18-82", SUM(y."Z18-91") AS "Z18-91", SUM(y."Z18-92") AS "Z18-92", SUM(y."Z18-A1") AS "Z18-A1", SUM(y."Z18-A2") AS "Z18-A2", SUM(y."Z18-B1") AS "Z18-B1", SUM(y."Z18-B2") AS "Z18-B2", SUM(y."Z18-C1") AS "Z18-C1", SUM(y."Z18-C2") AS "Z18-C2", SUM(y."Z18-D1") AS "Z18-D1", SUM(y."Z18-D2") AS "Z18-D2", -- + 19 SUM(y."Z19-AA") AS "Z19-AA", SUM(y."Z19-BB") AS "Z19-BB", SUM(y."Z19-CC") AS "Z19-CC", SUM(y."Z19-11") AS "Z19-11", SUM(y."Z19-12") AS "Z19-12", SUM(y."Z19-21") AS "Z19-21", SUM(y."Z19-22") AS "Z19-22", SUM(y."Z19-31") AS "Z19-31", SUM(y."Z19-32") AS "Z19-32", SUM(y."Z19-41") AS "Z19-41", SUM(y."Z19-42") AS "Z19-42", SUM(y."Z19-51") AS "Z19-51", SUM(y."Z19-52") AS "Z19-52", SUM(y."Z19-61") AS "Z19-61", SUM(y."Z19-62") AS "Z19-62", SUM(y."Z19-71") AS "Z19-71", SUM(y."Z19-72") AS "Z19-72", SUM(y."Z19-81") AS "Z19-81", SUM(y."Z19-82") AS "Z19-82", SUM(y."Z19-91") AS "Z19-91", SUM(y."Z19-92") AS "Z19-92", SUM(y."Z19-A1") AS "Z19-A1", SUM(y."Z19-A2") AS "Z19-A2", SUM(y."Z19-B1") AS "Z19-B1", SUM(y."Z19-B2") AS "Z19-B2", SUM(y."Z19-C1") AS "Z19-C1", SUM(y."Z19-C2") AS "Z19-C2", SUM(y."Z19-D1") AS "Z19-D1", SUM(y."Z19-D2") AS "Z19-D2", -- + 20 SUM(y."Z20-AA") AS "Z20-AA", SUM(y."Z20-BB") AS "Z20-BB", SUM(y."Z20-CC") AS "Z20-CC", SUM(y."Z20-11") AS "Z20-11", SUM(y."Z20-12") AS "Z20-12", SUM(y."Z20-21") AS "Z20-21", SUM(y."Z20-22") AS "Z20-22", SUM(y."Z20-31") AS "Z20-31", SUM(y."Z20-32") AS "Z20-32", SUM(y."Z20-41") AS "Z20-41", SUM(y."Z20-42") AS "Z20-42", SUM(y."Z20-51") AS "Z20-51", SUM(y."Z20-52") AS "Z20-52", SUM(y."Z20-61") AS "Z20-61", SUM(y."Z20-62") AS "Z20-62", SUM(y."Z20-71") AS "Z20-71", SUM(y."Z20-72") AS "Z20-72", SUM(y."Z20-81") AS "Z20-81", SUM(y."Z20-82") AS "Z20-82", SUM(y."Z20-91") AS "Z20-91", SUM(y."Z20-92") AS "Z20-92", SUM(y."Z20-A1") AS "Z20-A1", SUM(y."Z20-A2") AS "Z20-A2", SUM(y."Z20-B1") AS "Z20-B1", SUM(y."Z20-B2") AS "Z20-B2", SUM(y."Z20-C1") AS "Z20-C1", SUM(y."Z20-C2") AS "Z20-C2", SUM(y."Z20-D1") AS "Z20-D1", SUM(y."Z20-D2") AS "Z20-D2", -- + 21 SUM(y."Z21-AA") AS "Z21-AA", SUM(y."Z21-BB") AS "Z21-BB", SUM(y."Z21-CC") AS "Z21-CC", SUM(y."Z21-11") AS "Z21-11", SUM(y."Z21-12") AS "Z21-12", SUM(y."Z21-21") AS "Z21-21", SUM(y."Z21-22") AS "Z21-22", SUM(y."Z21-31") AS "Z21-31", SUM(y."Z21-32") AS "Z21-32", SUM(y."Z21-41") AS "Z21-41", SUM(y."Z21-42") AS "Z21-42", SUM(y."Z21-51") AS "Z21-51", SUM(y."Z21-52") AS "Z21-52", SUM(y."Z21-61") AS "Z21-61", SUM(y."Z21-62") AS "Z21-62", SUM(y."Z21-71") AS "Z21-71", SUM(y."Z21-72") AS "Z21-72", SUM(y."Z21-81") AS "Z21-81", SUM(y."Z21-82") AS "Z21-82", SUM(y."Z21-91") AS "Z21-91", SUM(y."Z21-92") AS "Z21-92", SUM(y."Z21-A1") AS "Z21-A1", SUM(y."Z21-A2") AS "Z21-A2", SUM(y."Z21-B1") AS "Z21-B1", SUM(y."Z21-B2") AS "Z21-B2", SUM(y."Z21-C1") AS "Z21-C1", SUM(y."Z21-C2") AS "Z21-C2", SUM(y."Z21-D1") AS "Z21-D1", SUM(y."Z21-D2") AS "Z21-D2", -- + 22 SUM(y."Z22-AA") AS "Z22-AA", SUM(y."Z22-BB") AS "Z22-BB", SUM(y."Z22-CC") AS "Z22-CC", SUM(y."Z22-11") AS "Z22-11", SUM(y."Z22-12") AS "Z22-12", SUM(y."Z22-21") AS "Z22-21", SUM(y."Z22-22") AS "Z22-22", SUM(y."Z22-31") AS "Z22-31", SUM(y."Z22-32") AS "Z22-32", SUM(y."Z22-41") AS "Z22-41", SUM(y."Z22-42") AS "Z22-42", SUM(y."Z22-51") AS "Z22-51", SUM(y."Z22-52") AS "Z22-52", SUM(y."Z22-61") AS "Z22-61", SUM(y."Z22-62") AS "Z22-62", SUM(y."Z22-71") AS "Z22-71", SUM(y."Z22-72") AS "Z22-72", SUM(y."Z22-81") AS "Z22-81", SUM(y."Z22-82") AS "Z22-82", SUM(y."Z22-91") AS "Z22-91", SUM(y."Z22-92") AS "Z22-92", SUM(y."Z22-A1") AS "Z22-A1", SUM(y."Z22-A2") AS "Z22-A2", SUM(y."Z22-B1") AS "Z22-B1", SUM(y."Z22-B2") AS "Z22-B2", SUM(y."Z22-C1") AS "Z22-C1", SUM(y."Z22-C2") AS "Z22-C2", SUM(y."Z22-D1") AS "Z22-D1", SUM(y."Z22-D2") AS "Z22-D2", -- + 23 SUM(y."Z23-AA") AS "Z23-AA", SUM(y."Z23-BB") AS "Z23-BB", SUM(y."Z23-CC") AS "Z23-CC", SUM(y."Z23-11") AS "Z23-11", SUM(y."Z23-12") AS "Z23-12", SUM(y."Z23-21") AS "Z23-21", SUM(y."Z23-22") AS "Z23-22", SUM(y."Z23-31") AS "Z23-31", SUM(y."Z23-32") AS "Z23-32", SUM(y."Z23-41") AS "Z23-41", SUM(y."Z23-42") AS "Z23-42", SUM(y."Z23-51") AS "Z23-51", SUM(y."Z23-52") AS "Z23-52", SUM(y."Z23-61") AS "Z23-61", SUM(y."Z23-62") AS "Z23-62", SUM(y."Z23-71") AS "Z23-71", SUM(y."Z23-72") AS "Z23-72", SUM(y."Z23-81") AS "Z23-81", SUM(y."Z23-82") AS "Z23-82", SUM(y."Z23-91") AS "Z23-91", SUM(y."Z23-92") AS "Z23-92", SUM(y."Z23-A1") AS "Z23-A1", SUM(y."Z23-A2") AS "Z23-A2", SUM(y."Z23-B1") AS "Z23-B1", SUM(y."Z23-B2") AS "Z23-B2", SUM(y."Z23-C1") AS "Z23-C1", SUM(y."Z23-C2") AS "Z23-C2", SUM(y."Z23-D1") AS "Z23-D1", SUM(y."Z23-D2") AS "Z23-D2", -- + 24 SUM(y."Z24-AA") AS "Z24-AA", SUM(y."Z24-BB") AS "Z24-BB", SUM(y."Z24-CC") AS "Z24-CC", SUM(y."Z24-11") AS "Z24-11", SUM(y."Z24-12") AS "Z24-12", SUM(y."Z24-21") AS "Z24-21", SUM(y."Z24-22") AS "Z24-22", SUM(y."Z24-31") AS "Z24-31", SUM(y."Z24-32") AS "Z24-32", SUM(y."Z24-41") AS "Z24-41", SUM(y."Z24-42") AS "Z24-42", SUM(y."Z24-51") AS "Z24-51", SUM(y."Z24-52") AS "Z24-52", SUM(y."Z24-61") AS "Z24-61", SUM(y."Z24-62") AS "Z24-62", SUM(y."Z24-71") AS "Z24-71", SUM(y."Z24-72") AS "Z24-72", SUM(y."Z24-81") AS "Z24-81", SUM(y."Z24-82") AS "Z24-82", SUM(y."Z24-91") AS "Z24-91", SUM(y."Z24-92") AS "Z24-92", SUM(y."Z24-A1") AS "Z24-A1", SUM(y."Z24-A2") AS "Z24-A2", SUM(y."Z24-B1") AS "Z24-B1", SUM(y."Z24-B2") AS "Z24-B2", SUM(y."Z24-C1") AS "Z24-C1", SUM(y."Z24-C2") AS "Z24-C2", SUM(y."Z24-D1") AS "Z24-D1", SUM(y."Z24-D2") AS "Z24-D2", -- + 25 SUM(y."Z25-AA") AS "Z25-AA", SUM(y."Z25-BB") AS "Z25-BB", SUM(y."Z25-CC") AS "Z25-CC", SUM(y."Z25-11") AS "Z25-11", SUM(y."Z25-12") AS "Z25-12", SUM(y."Z25-21") AS "Z25-21", SUM(y."Z25-22") AS "Z25-22", SUM(y."Z25-31") AS "Z25-31", SUM(y."Z25-32") AS "Z25-32", SUM(y."Z25-41") AS "Z25-41", SUM(y."Z25-42") AS "Z25-42", SUM(y."Z25-51") AS "Z25-51", SUM(y."Z25-52") AS "Z25-52", SUM(y."Z25-61") AS "Z25-61", SUM(y."Z25-62") AS "Z25-62", SUM(y."Z25-71") AS "Z25-71", SUM(y."Z25-72") AS "Z25-72", SUM(y."Z25-81") AS "Z25-81", SUM(y."Z25-82") AS "Z25-82", SUM(y."Z25-91") AS "Z25-91", SUM(y."Z25-92") AS "Z25-92", SUM(y."Z25-A1") AS "Z25-A1", SUM(y."Z25-A2") AS "Z25-A2", SUM(y."Z25-B1") AS "Z25-B1", SUM(y."Z25-B2") AS "Z25-B2", SUM(y."Z25-C1") AS "Z25-C1", SUM(y."Z25-C2") AS "Z25-C2", SUM(y."Z25-D1") AS "Z25-D1", SUM(y."Z25-D2") AS "Z25-D2", -- + 26 SUM(y."Z26-AA") AS "Z26-AA", SUM(y."Z26-BB") AS "Z26-BB", SUM(y."Z26-CC") AS "Z26-CC", SUM(y."Z26-11") AS "Z26-11", SUM(y."Z26-12") AS "Z26-12", SUM(y."Z26-21") AS "Z26-21", SUM(y."Z26-22") AS "Z26-22", SUM(y."Z26-31") AS "Z26-31", SUM(y."Z26-32") AS "Z26-32", SUM(y."Z26-41") AS "Z26-41", SUM(y."Z26-42") AS "Z26-42", SUM(y."Z26-51") AS "Z26-51", SUM(y."Z26-52") AS "Z26-52", SUM(y."Z26-61") AS "Z26-61", SUM(y."Z26-62") AS "Z26-62", SUM(y."Z26-71") AS "Z26-71", SUM(y."Z26-72") AS "Z26-72", SUM(y."Z26-81") AS "Z26-81", SUM(y."Z26-82") AS "Z26-82", SUM(y."Z26-91") AS "Z26-91", SUM(y."Z26-92") AS "Z26-92", SUM(y."Z26-A1") AS "Z26-A1", SUM(y."Z26-A2") AS "Z26-A2", SUM(y."Z26-B1") AS "Z26-B1", SUM(y."Z26-B2") AS "Z26-B2", SUM(y."Z26-C1") AS "Z26-C1", SUM(y."Z26-C2") AS "Z26-C2", SUM(y."Z26-D1") AS "Z26-D1", SUM(y."Z26-D2") AS "Z26-D2", -- + 27 SUM(y."Z27-AA") AS "Z27-AA", SUM(y."Z27-BB") AS "Z27-BB", SUM(y."Z27-CC") AS "Z27-CC", SUM(y."Z27-11") AS "Z27-11", SUM(y."Z27-12") AS "Z27-12", SUM(y."Z27-21") AS "Z27-21", SUM(y."Z27-22") AS "Z27-22", SUM(y."Z27-31") AS "Z27-31", SUM(y."Z27-32") AS "Z27-32", SUM(y."Z27-41") AS "Z27-41", SUM(y."Z27-42") AS "Z27-42", SUM(y."Z27-51") AS "Z27-51", SUM(y."Z27-52") AS "Z27-52", SUM(y."Z27-61") AS "Z27-61", SUM(y."Z27-62") AS "Z27-62", SUM(y."Z27-71") AS "Z27-71", SUM(y."Z27-72") AS "Z27-72", SUM(y."Z27-81") AS "Z27-81", SUM(y."Z27-82") AS "Z27-82", SUM(y."Z27-91") AS "Z27-91", SUM(y."Z27-92") AS "Z27-92", SUM(y."Z27-A1") AS "Z27-A1", SUM(y."Z27-A2") AS "Z27-A2", SUM(y."Z27-B1") AS "Z27-B1", SUM(y."Z27-B2") AS "Z27-B2", SUM(y."Z27-C1") AS "Z27-C1", SUM(y."Z27-C2") AS "Z27-C2", SUM(y."Z27-D1") AS "Z27-D1", SUM(y."Z27-D2") AS "Z27-D2", -- + 28 SUM(y."Z28-AA") AS "Z28-AA", SUM(y."Z28-BB") AS "Z28-BB", SUM(y."Z28-CC") AS "Z28-CC", SUM(y."Z28-11") AS "Z28-11", SUM(y."Z28-12") AS "Z28-12", SUM(y."Z28-21") AS "Z28-21", SUM(y."Z28-22") AS "Z28-22", SUM(y."Z28-31") AS "Z28-31", SUM(y."Z28-32") AS "Z28-32", SUM(y."Z28-41") AS "Z28-41", SUM(y."Z28-42") AS "Z28-42", SUM(y."Z28-51") AS "Z28-51", SUM(y."Z28-52") AS "Z28-52", SUM(y."Z28-61") AS "Z28-61", SUM(y."Z28-62") AS "Z28-62", SUM(y."Z28-71") AS "Z28-71", SUM(y."Z28-72") AS "Z28-72", SUM(y."Z28-81") AS "Z28-81", SUM(y."Z28-82") AS "Z28-82", SUM(y."Z28-91") AS "Z28-91", SUM(y."Z28-92") AS "Z28-92", SUM(y."Z28-A1") AS "Z28-A1", SUM(y."Z28-A2") AS "Z28-A2", SUM(y."Z28-B1") AS "Z28-B1", SUM(y."Z28-B2") AS "Z28-B2", SUM(y."Z28-C1") AS "Z28-C1", SUM(y."Z28-C2") AS "Z28-C2", SUM(y."Z28-D1") AS "Z28-D1", SUM(y."Z28-D2") AS "Z28-D2", -- + 29 SUM(y."Z29-AA") AS "Z29-AA", SUM(y."Z29-BB") AS "Z29-BB", SUM(y."Z29-CC") AS "Z29-CC", SUM(y."Z29-11") AS "Z29-11", SUM(y."Z29-12") AS "Z29-12", SUM(y."Z29-21") AS "Z29-21", SUM(y."Z29-22") AS "Z29-22", SUM(y."Z29-31") AS "Z29-31", SUM(y."Z29-32") AS "Z29-32", SUM(y."Z29-41") AS "Z29-41", SUM(y."Z29-42") AS "Z29-42", SUM(y."Z29-51") AS "Z29-51", SUM(y."Z29-52") AS "Z29-52", SUM(y."Z29-61") AS "Z29-61", SUM(y."Z29-62") AS "Z29-62", SUM(y."Z29-71") AS "Z29-71", SUM(y."Z29-72") AS "Z29-72", SUM(y."Z29-81") AS "Z29-81", SUM(y."Z29-82") AS "Z29-82", SUM(y."Z29-91") AS "Z29-91", SUM(y."Z29-92") AS "Z29-92", SUM(y."Z29-A1") AS "Z29-A1", SUM(y."Z29-A2") AS "Z29-A2", SUM(y."Z29-B1") AS "Z29-B1", SUM(y."Z29-B2") AS "Z29-B2", SUM(y."Z29-C1") AS "Z29-C1", SUM(y."Z29-C2") AS "Z29-C2", SUM(y."Z29-D1") AS "Z29-D1", SUM(y."Z29-D2") AS "Z29-D2", -- + 30 SUM(y."Z30-AA") AS "Z30-AA", SUM(y."Z30-BB") AS "Z30-BB", SUM(y."Z30-CC") AS "Z30-CC", SUM(y."Z30-11") AS "Z30-11", SUM(y."Z30-12") AS "Z30-12", SUM(y."Z30-21") AS "Z30-21", SUM(y."Z30-22") AS "Z30-22", SUM(y."Z30-31") AS "Z30-31", SUM(y."Z30-32") AS "Z30-32", SUM(y."Z30-41") AS "Z30-41", SUM(y."Z30-42") AS "Z30-42", SUM(y."Z30-51") AS "Z30-51", SUM(y."Z30-52") AS "Z30-52", SUM(y."Z30-61") AS "Z30-61", SUM(y."Z30-62") AS "Z30-62", SUM(y."Z30-71") AS "Z30-71", SUM(y."Z30-72") AS "Z30-72", SUM(y."Z30-81") AS "Z30-81", SUM(y."Z30-82") AS "Z30-82", SUM(y."Z30-91") AS "Z30-91", SUM(y."Z30-92") AS "Z30-92", SUM(y."Z30-A1") AS "Z30-A1", SUM(y."Z30-A2") AS "Z30-A2", SUM(y."Z30-B1") AS "Z30-B1", SUM(y."Z30-B2") AS "Z30-B2", SUM(y."Z30-C1") AS "Z30-C1", SUM(y."Z30-C2") AS "Z30-C2", SUM(y."Z30-D1") AS "Z30-D1", SUM(y."Z30-D2") AS "Z30-D2", -- + 31 SUM(y."Z31-AA") AS "Z31-AA", SUM(y."Z31-BB") AS "Z31-BB", SUM(y."Z31-CC") AS "Z31-CC", SUM(y."Z31-11") AS "Z31-11", SUM(y."Z31-12") AS "Z31-12", SUM(y."Z31-21") AS "Z31-21", SUM(y."Z31-22") AS "Z31-22", SUM(y."Z31-31") AS "Z31-31", SUM(y."Z31-32") AS "Z31-32", SUM(y."Z31-41") AS "Z31-41", SUM(y."Z31-42") AS "Z31-42", SUM(y."Z31-51") AS "Z31-51", SUM(y."Z31-52") AS "Z31-52", SUM(y."Z31-61") AS "Z31-61", SUM(y."Z31-62") AS "Z31-62", SUM(y."Z31-71") AS "Z31-71", SUM(y."Z31-72") AS "Z31-72", SUM(y."Z31-81") AS "Z31-81", SUM(y."Z31-82") AS "Z31-82", SUM(y."Z31-91") AS "Z31-91", SUM(y."Z31-92") AS "Z31-92", SUM(y."Z31-A1") AS "Z31-A1", SUM(y."Z31-A2") AS "Z31-A2", SUM(y."Z31-B1") AS "Z31-B1", SUM(y."Z31-B2") AS "Z31-B2", SUM(y."Z31-C1") AS "Z31-C1", SUM(y."Z31-C2") AS "Z31-C2", SUM(y."Z31-D1") AS "Z31-D1", SUM(y."Z31-D2") AS "Z31-D2", -- + 32 SUM(y."Z32-AA") AS "Z32-AA", SUM(y."Z32-BB") AS "Z32-BB", SUM(y."Z32-CC") AS "Z32-CC", SUM(y."Z32-11") AS "Z32-11", SUM(y."Z32-12") AS "Z32-12", SUM(y."Z32-21") AS "Z32-21", SUM(y."Z32-22") AS "Z32-22", SUM(y."Z32-31") AS "Z32-31", SUM(y."Z32-32") AS "Z32-32", SUM(y."Z32-41") AS "Z32-41", SUM(y."Z32-42") AS "Z32-42", SUM(y."Z32-51") AS "Z32-51", SUM(y."Z32-52") AS "Z32-52", SUM(y."Z32-61") AS "Z32-61", SUM(y."Z32-62") AS "Z32-62", SUM(y."Z32-71") AS "Z32-71", SUM(y."Z32-72") AS "Z32-72", SUM(y."Z32-81") AS "Z32-81", SUM(y."Z32-82") AS "Z32-82", SUM(y."Z32-91") AS "Z32-91", SUM(y."Z32-92") AS "Z32-92", SUM(y."Z32-A1") AS "Z32-A1", SUM(y."Z32-A2") AS "Z32-A2", SUM(y."Z32-B1") AS "Z32-B1", SUM(y."Z32-B2") AS "Z32-B2", SUM(y."Z32-C1") AS "Z32-C1", SUM(y."Z32-C2") AS "Z32-C2", SUM(y."Z32-D1") AS "Z32-D1", SUM(y."Z32-D2") AS "Z32-D2", -- + 33 SUM(y."Z33-AA") AS "Z33-AA", SUM(y."Z33-BB") AS "Z33-BB", SUM(y."Z33-CC") AS "Z33-CC", SUM(y."Z33-11") AS "Z33-11", SUM(y."Z33-12") AS "Z33-12", SUM(y."Z33-21") AS "Z33-21", SUM(y."Z33-22") AS "Z33-22", SUM(y."Z33-31") AS "Z33-31", SUM(y."Z33-32") AS "Z33-32", SUM(y."Z33-41") AS "Z33-41", SUM(y."Z33-42") AS "Z33-42", SUM(y."Z33-51") AS "Z33-51", SUM(y."Z33-52") AS "Z33-52", SUM(y."Z33-61") AS "Z33-61", SUM(y."Z33-62") AS "Z33-62", SUM(y."Z33-71") AS "Z33-71", SUM(y."Z33-72") AS "Z33-72", SUM(y."Z33-81") AS "Z33-81", SUM(y."Z33-82") AS "Z33-82", SUM(y."Z33-91") AS "Z33-91", SUM(y."Z33-92") AS "Z33-92", SUM(y."Z33-A1") AS "Z33-A1", SUM(y."Z33-A2") AS "Z33-A2", SUM(y."Z33-B1") AS "Z33-B1", SUM(y."Z33-B2") AS "Z33-B2", SUM(y."Z33-C1") AS "Z33-C1", SUM(y."Z33-C2") AS "Z33-C2", SUM(y."Z33-D1") AS "Z33-D1", SUM(y."Z33-D2") AS "Z33-D2" FROM ( SELECT x."FamilyId", -- + 03 CASE WHEN SUM(x."x03")>2 THEN 1 ELSE 0 END AS "Z03-AA", -- семей CASE WHEN SUM(x."x03")>2 THEN SUM(x."x01") ELSE 0 END AS "Z03-BB", -- граждан в семях CASE WHEN SUM(x."x03")>2 THEN SUM(x."rE0") ELSE 0 END AS "Z03-CC", -- патронатов CASE WHEN SUM(x."x03")>2 THEN SUM(x."r11") ELSE 0 END AS "Z03-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x03")>2 THEN SUM(x."r12") ELSE 0 END AS "Z03-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x03")>2 THEN SUM(x."r21") ELSE 0 END AS "Z03-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x03")>2 THEN SUM(x."r22") ELSE 0 END AS "Z03-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x03")>2 THEN SUM(x."r31") ELSE 0 END AS "Z03-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x03")>2 THEN SUM(x."r32") ELSE 0 END AS "Z03-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x03")>2 THEN SUM(x."r41") ELSE 0 END AS "Z03-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x03")>2 THEN SUM(x."r42") ELSE 0 END AS "Z03-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x03")>2 THEN SUM(x."r51") ELSE 0 END AS "Z03-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x03")>2 THEN SUM(x."r52") ELSE 0 END AS "Z03-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x03")>2 THEN SUM(x."r61") ELSE 0 END AS "Z03-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x03")>2 THEN SUM(x."r62") ELSE 0 END AS "Z03-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x03")>2 THEN SUM(x."r71") ELSE 0 END AS "Z03-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x03")>2 THEN SUM(x."r72") ELSE 0 END AS "Z03-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x03")>2 THEN SUM(x."r81") ELSE 0 END AS "Z03-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x03")>2 THEN SUM(x."r82") ELSE 0 END AS "Z03-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x03")>2 THEN SUM(x."r91") ELSE 0 END AS "Z03-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x03")>2 THEN SUM(x."r92") ELSE 0 END AS "Z03-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x03")>2 THEN SUM(x."rA1") ELSE 0 END AS "Z03-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x03")>2 THEN SUM(x."rA2") ELSE 0 END AS "Z03-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x03")>2 THEN SUM(x."rB1") ELSE 0 END AS "Z03-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x03")>2 THEN SUM(x."rB2") ELSE 0 END AS "Z03-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x03")>2 THEN SUM(x."rC1") ELSE 0 END AS "Z03-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x03")>2 THEN SUM(x."rC2") ELSE 0 END AS "Z03-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x03")>2 THEN SUM(x."rD1") ELSE 0 END AS "Z03-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x03")>2 THEN SUM(x."rD2") ELSE 0 END AS "Z03-D2", -- консультация (дети ) Иное -- + 04 CASE WHEN SUM(x."x05")>0 THEN 1 ELSE 0 END AS "Z04-AA", -- семей CASE WHEN SUM(x."x05")>0 THEN SUM(x."x01") ELSE 0 END AS "Z04-BB", -- граждан в семях CASE WHEN SUM(x."x05")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z04-CC", -- патронатов CASE WHEN SUM(x."x05")>0 THEN SUM(x."r11") ELSE 0 END AS "Z04-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x05")>0 THEN SUM(x."r12") ELSE 0 END AS "Z04-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x05")>0 THEN SUM(x."r21") ELSE 0 END AS "Z04-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x05")>0 THEN SUM(x."r22") ELSE 0 END AS "Z04-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x05")>0 THEN SUM(x."r31") ELSE 0 END AS "Z04-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x05")>0 THEN SUM(x."r32") ELSE 0 END AS "Z04-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x05")>0 THEN SUM(x."r41") ELSE 0 END AS "Z04-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x05")>0 THEN SUM(x."r42") ELSE 0 END AS "Z04-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x05")>0 THEN SUM(x."r51") ELSE 0 END AS "Z04-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x05")>0 THEN SUM(x."r52") ELSE 0 END AS "Z04-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x05")>0 THEN SUM(x."r61") ELSE 0 END AS "Z04-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x05")>0 THEN SUM(x."r62") ELSE 0 END AS "Z04-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x05")>0 THEN SUM(x."r71") ELSE 0 END AS "Z04-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x05")>0 THEN SUM(x."r72") ELSE 0 END AS "Z04-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x05")>0 THEN SUM(x."r81") ELSE 0 END AS "Z04-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x05")>0 THEN SUM(x."r82") ELSE 0 END AS "Z04-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x05")>0 THEN SUM(x."r91") ELSE 0 END AS "Z04-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x05")>0 THEN SUM(x."r92") ELSE 0 END AS "Z04-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x05")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z04-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x05")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z04-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x05")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z04-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x05")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z04-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x05")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z04-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x05")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z04-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x05")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z04-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x05")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z04-D2", -- консультация (дети ) Иное -- + 06 CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN 1 ELSE 0 END AS "Z06-AA", -- семей CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."x01") ELSE 0 END AS "Z06-BB", -- граждан в семях CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z06-CC", -- патронатов CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r11") ELSE 0 END AS "Z06-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r12") ELSE 0 END AS "Z06-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r21") ELSE 0 END AS "Z06-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r22") ELSE 0 END AS "Z06-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r31") ELSE 0 END AS "Z06-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r32") ELSE 0 END AS "Z06-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r41") ELSE 0 END AS "Z06-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r42") ELSE 0 END AS "Z06-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r51") ELSE 0 END AS "Z06-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r52") ELSE 0 END AS "Z06-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r61") ELSE 0 END AS "Z06-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r62") ELSE 0 END AS "Z06-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r71") ELSE 0 END AS "Z06-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r72") ELSE 0 END AS "Z06-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r81") ELSE 0 END AS "Z06-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r82") ELSE 0 END AS "Z06-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r91") ELSE 0 END AS "Z06-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."r92") ELSE 0 END AS "Z06-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z06-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z06-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z06-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z06-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z06-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z06-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z06-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x06")=1 AND SUM(x."x03")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z06-D2", -- консультация (дети ) Иное -- + 07 CASE WHEN SUM(x."x07")>0 THEN 1 ELSE 0 END AS "Z07-AA", -- семей CASE WHEN SUM(x."x07")>0 THEN SUM(x."x01") ELSE 0 END AS "Z07-BB", -- граждан в семях CASE WHEN SUM(x."x07")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z07-CC", -- патронатов CASE WHEN SUM(x."x07")>0 THEN SUM(x."r11") ELSE 0 END AS "Z07-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x07")>0 THEN SUM(x."r12") ELSE 0 END AS "Z07-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x07")>0 THEN SUM(x."r21") ELSE 0 END AS "Z07-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x07")>0 THEN SUM(x."r22") ELSE 0 END AS "Z07-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x07")>0 THEN SUM(x."r31") ELSE 0 END AS "Z07-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x07")>0 THEN SUM(x."r32") ELSE 0 END AS "Z07-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x07")>0 THEN SUM(x."r41") ELSE 0 END AS "Z07-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x07")>0 THEN SUM(x."r42") ELSE 0 END AS "Z07-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x07")>0 THEN SUM(x."r51") ELSE 0 END AS "Z07-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x07")>0 THEN SUM(x."r52") ELSE 0 END AS "Z07-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x07")>0 THEN SUM(x."r61") ELSE 0 END AS "Z07-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x07")>0 THEN SUM(x."r62") ELSE 0 END AS "Z07-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x07")>0 THEN SUM(x."r71") ELSE 0 END AS "Z07-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x07")>0 THEN SUM(x."r72") ELSE 0 END AS "Z07-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x07")>0 THEN SUM(x."r81") ELSE 0 END AS "Z07-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x07")>0 THEN SUM(x."r82") ELSE 0 END AS "Z07-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x07")>0 THEN SUM(x."r91") ELSE 0 END AS "Z07-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x07")>0 THEN SUM(x."r92") ELSE 0 END AS "Z07-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x07")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z07-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x07")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z07-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x07")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z07-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x07")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z07-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x07")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z07-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x07")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z07-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x07")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z07-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x07")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z07-D2", -- консультация (дети ) Иное -- + 08 CASE WHEN SUM(x."x08")>0 THEN 1 ELSE 0 END AS "Z08-AA", -- семей CASE WHEN SUM(x."x08")>0 THEN SUM(x."x01") ELSE 0 END AS "Z08-BB", -- граждан в семях CASE WHEN SUM(x."x08")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z08-CC", -- патронатов CASE WHEN SUM(x."x08")>0 THEN SUM(x."r11") ELSE 0 END AS "Z08-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x08")>0 THEN SUM(x."r12") ELSE 0 END AS "Z08-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x08")>0 THEN SUM(x."r21") ELSE 0 END AS "Z08-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x08")>0 THEN SUM(x."r22") ELSE 0 END AS "Z08-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x08")>0 THEN SUM(x."r31") ELSE 0 END AS "Z08-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x08")>0 THEN SUM(x."r32") ELSE 0 END AS "Z08-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x08")>0 THEN SUM(x."r41") ELSE 0 END AS "Z08-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x08")>0 THEN SUM(x."r42") ELSE 0 END AS "Z08-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x08")>0 THEN SUM(x."r51") ELSE 0 END AS "Z08-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x08")>0 THEN SUM(x."r52") ELSE 0 END AS "Z08-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x08")>0 THEN SUM(x."r61") ELSE 0 END AS "Z08-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x08")>0 THEN SUM(x."r62") ELSE 0 END AS "Z08-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x08")>0 THEN SUM(x."r71") ELSE 0 END AS "Z08-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x08")>0 THEN SUM(x."r72") ELSE 0 END AS "Z08-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x08")>0 THEN SUM(x."r81") ELSE 0 END AS "Z08-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x08")>0 THEN SUM(x."r82") ELSE 0 END AS "Z08-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x08")>0 THEN SUM(x."r91") ELSE 0 END AS "Z08-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x08")>0 THEN SUM(x."r92") ELSE 0 END AS "Z08-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x08")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z08-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x08")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z08-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x08")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z08-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x08")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z08-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x08")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z08-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x08")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z08-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x08")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z08-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x08")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z08-D2", -- консультация (дети ) Иное -- + 09 CASE WHEN SUM(x."x09")>0 THEN 1 ELSE 0 END AS "Z09-AA", -- семей CASE WHEN SUM(x."x09")>0 THEN SUM(x."x01") ELSE 0 END AS "Z09-BB", -- граждан в семях CASE WHEN SUM(x."x09")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z09-CC", -- патронатов CASE WHEN SUM(x."x09")>0 THEN SUM(x."r11") ELSE 0 END AS "Z09-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x09")>0 THEN SUM(x."r12") ELSE 0 END AS "Z09-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x09")>0 THEN SUM(x."r21") ELSE 0 END AS "Z09-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x09")>0 THEN SUM(x."r22") ELSE 0 END AS "Z09-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x09")>0 THEN SUM(x."r31") ELSE 0 END AS "Z09-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x09")>0 THEN SUM(x."r32") ELSE 0 END AS "Z09-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x09")>0 THEN SUM(x."r41") ELSE 0 END AS "Z09-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x09")>0 THEN SUM(x."r42") ELSE 0 END AS "Z09-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x09")>0 THEN SUM(x."r51") ELSE 0 END AS "Z09-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x09")>0 THEN SUM(x."r52") ELSE 0 END AS "Z09-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x09")>0 THEN SUM(x."r61") ELSE 0 END AS "Z09-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x09")>0 THEN SUM(x."r62") ELSE 0 END AS "Z09-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x09")>0 THEN SUM(x."r71") ELSE 0 END AS "Z09-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x09")>0 THEN SUM(x."r72") ELSE 0 END AS "Z09-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x09")>0 THEN SUM(x."r81") ELSE 0 END AS "Z09-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x09")>0 THEN SUM(x."r82") ELSE 0 END AS "Z09-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x09")>0 THEN SUM(x."r91") ELSE 0 END AS "Z09-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x09")>0 THEN SUM(x."r92") ELSE 0 END AS "Z09-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x09")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z09-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x09")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z09-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x09")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z09-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x09")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z09-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x09")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z09-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x09")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z09-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x09")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z09-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x09")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z09-D2", -- консультация (дети ) Иное -- + 10 CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN 1 ELSE 0 END AS "Z10-AA", -- семей CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."x01") ELSE 0 END AS "Z10-BB", -- граждан в семях CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z10-CC", -- патронатов CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r11") ELSE 0 END AS "Z10-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r12") ELSE 0 END AS "Z10-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r21") ELSE 0 END AS "Z10-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r22") ELSE 0 END AS "Z10-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r31") ELSE 0 END AS "Z10-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r32") ELSE 0 END AS "Z10-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r41") ELSE 0 END AS "Z10-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r42") ELSE 0 END AS "Z10-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r51") ELSE 0 END AS "Z10-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r52") ELSE 0 END AS "Z10-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r61") ELSE 0 END AS "Z10-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r62") ELSE 0 END AS "Z10-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r71") ELSE 0 END AS "Z10-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r72") ELSE 0 END AS "Z10-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r81") ELSE 0 END AS "Z10-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r82") ELSE 0 END AS "Z10-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r91") ELSE 0 END AS "Z10-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."r92") ELSE 0 END AS "Z10-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z10-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z10-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z10-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z10-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z10-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z10-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z10-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x10")>0 AND SUM(x."x03")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z10-D2", -- консультация (дети ) Иное -- + 11 CASE WHEN SUM(x."x11")=1 THEN 1 ELSE 0 END AS "Z11-AA", -- семей CASE WHEN SUM(x."x11")=1 THEN SUM(x."x01") ELSE 0 END AS "Z11-BB", -- граждан в семях CASE WHEN SUM(x."x11")=1 THEN SUM(x."rE0") ELSE 0 END AS "Z11-CC", -- патронатов CASE WHEN SUM(x."x11")=1 THEN SUM(x."r11") ELSE 0 END AS "Z11-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x11")=1 THEN SUM(x."r12") ELSE 0 END AS "Z11-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x11")=1 THEN SUM(x."r21") ELSE 0 END AS "Z11-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x11")=1 THEN SUM(x."r22") ELSE 0 END AS "Z11-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x11")=1 THEN SUM(x."r31") ELSE 0 END AS "Z11-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x11")=1 THEN SUM(x."r32") ELSE 0 END AS "Z11-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x11")=1 THEN SUM(x."r41") ELSE 0 END AS "Z11-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x11")=1 THEN SUM(x."r42") ELSE 0 END AS "Z11-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x11")=1 THEN SUM(x."r51") ELSE 0 END AS "Z11-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x11")=1 THEN SUM(x."r52") ELSE 0 END AS "Z11-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x11")=1 THEN SUM(x."r61") ELSE 0 END AS "Z11-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x11")=1 THEN SUM(x."r62") ELSE 0 END AS "Z11-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x11")=1 THEN SUM(x."r71") ELSE 0 END AS "Z11-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x11")=1 THEN SUM(x."r72") ELSE 0 END AS "Z11-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x11")=1 THEN SUM(x."r81") ELSE 0 END AS "Z11-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x11")=1 THEN SUM(x."r82") ELSE 0 END AS "Z11-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x11")=1 THEN SUM(x."r91") ELSE 0 END AS "Z11-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x11")=1 THEN SUM(x."r92") ELSE 0 END AS "Z11-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x11")=1 THEN SUM(x."rA1") ELSE 0 END AS "Z11-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x11")=1 THEN SUM(x."rA2") ELSE 0 END AS "Z11-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x11")=1 THEN SUM(x."rB1") ELSE 0 END AS "Z11-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x11")=1 THEN SUM(x."rB2") ELSE 0 END AS "Z11-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x11")=1 THEN SUM(x."rC1") ELSE 0 END AS "Z11-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x11")=1 THEN SUM(x."rC2") ELSE 0 END AS "Z11-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x11")=1 THEN SUM(x."rD1") ELSE 0 END AS "Z11-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x11")=1 THEN SUM(x."rD2") ELSE 0 END AS "Z11-D2", -- консультация (дети ) Иное -- + 16 CASE WHEN SUM(x."x16")>0 THEN 1 ELSE 0 END AS "Z16-AA", -- семей CASE WHEN SUM(x."x16")>0 THEN SUM(x."x01") ELSE 0 END AS "Z16-BB", -- граждан в семях CASE WHEN SUM(x."x16")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z16-CC", -- патронатов CASE WHEN SUM(x."x16")>0 THEN SUM(x."r11") ELSE 0 END AS "Z16-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x16")>0 THEN SUM(x."r12") ELSE 0 END AS "Z16-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x16")>0 THEN SUM(x."r21") ELSE 0 END AS "Z16-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x16")>0 THEN SUM(x."r22") ELSE 0 END AS "Z16-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x16")>0 THEN SUM(x."r31") ELSE 0 END AS "Z16-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x16")>0 THEN SUM(x."r32") ELSE 0 END AS "Z16-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x16")>0 THEN SUM(x."r41") ELSE 0 END AS "Z16-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x16")>0 THEN SUM(x."r42") ELSE 0 END AS "Z16-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x16")>0 THEN SUM(x."r51") ELSE 0 END AS "Z16-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x16")>0 THEN SUM(x."r52") ELSE 0 END AS "Z16-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x16")>0 THEN SUM(x."r61") ELSE 0 END AS "Z16-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x16")>0 THEN SUM(x."r62") ELSE 0 END AS "Z16-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x16")>0 THEN SUM(x."r71") ELSE 0 END AS "Z16-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x16")>0 THEN SUM(x."r72") ELSE 0 END AS "Z16-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x16")>0 THEN SUM(x."r81") ELSE 0 END AS "Z16-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x16")>0 THEN SUM(x."r82") ELSE 0 END AS "Z16-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x16")>0 THEN SUM(x."r91") ELSE 0 END AS "Z16-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x16")>0 THEN SUM(x."r92") ELSE 0 END AS "Z16-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x16")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z16-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x16")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z16-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x16")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z16-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x16")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z16-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x16")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z16-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x16")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z16-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x16")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z16-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x16")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z16-D2", -- консультация (дети ) Иное -- + 17 CASE WHEN MIN(x."x17")>0 THEN 1 ELSE 0 END AS "Z17-AA", -- семей CASE WHEN MIN(x."x17")>0 THEN SUM(x."x01") ELSE 0 END AS "Z17-BB", -- граждан в семях CASE WHEN MIN(x."x17")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z17-CC", -- патронатов CASE WHEN MIN(x."x17")>0 THEN SUM(x."r11") ELSE 0 END AS "Z17-11", -- консультация (взрослые) Психлологическая CASE WHEN MIN(x."x17")>0 THEN SUM(x."r12") ELSE 0 END AS "Z17-12", -- консультация (дети ) Психлологическая CASE WHEN MIN(x."x17")>0 THEN SUM(x."r21") ELSE 0 END AS "Z17-21", -- консультация (взрослые) Педагогическая CASE WHEN MIN(x."x17")>0 THEN SUM(x."r22") ELSE 0 END AS "Z17-22", -- консультация (дети ) Педагогическая CASE WHEN MIN(x."x17")>0 THEN SUM(x."r31") ELSE 0 END AS "Z17-31", -- консультация (взрослые) Юридическая CASE WHEN MIN(x."x17")>0 THEN SUM(x."r32") ELSE 0 END AS "Z17-32", -- консультация (дети ) Юридическая CASE WHEN MIN(x."x17")>0 THEN SUM(x."r41") ELSE 0 END AS "Z17-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN MIN(x."x17")>0 THEN SUM(x."r42") ELSE 0 END AS "Z17-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN MIN(x."x17")>0 THEN SUM(x."r51") ELSE 0 END AS "Z17-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN MIN(x."x17")>0 THEN SUM(x."r52") ELSE 0 END AS "Z17-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN MIN(x."x17")>0 THEN SUM(x."r61") ELSE 0 END AS "Z17-61", -- консультация (взрослые) Научно-методическая CASE WHEN MIN(x."x17")>0 THEN SUM(x."r62") ELSE 0 END AS "Z17-62", -- консультация (дети ) Научно-методическая CASE WHEN MIN(x."x17")>0 THEN SUM(x."r71") ELSE 0 END AS "Z17-71", -- консультация (взрослые) Информационная CASE WHEN MIN(x."x17")>0 THEN SUM(x."r72") ELSE 0 END AS "Z17-72", -- консультация (дети ) Информационная CASE WHEN MIN(x."x17")>0 THEN SUM(x."r81") ELSE 0 END AS "Z17-81", -- консультация (взрослые) Методическая CASE WHEN MIN(x."x17")>0 THEN SUM(x."r82") ELSE 0 END AS "Z17-82", -- консультация (дети ) Методическая CASE WHEN MIN(x."x17")>0 THEN SUM(x."r91") ELSE 0 END AS "Z17-91", -- консультация (взрослые) Иное CASE WHEN MIN(x."x17")>0 THEN SUM(x."r92") ELSE 0 END AS "Z17-92", -- консультация (дети ) Иное CASE WHEN MIN(x."x17")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z17-A1", -- консультация (взрослые) Группа CASE WHEN MIN(x."x17")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z17-A2", -- консультация (дети ) Группа CASE WHEN MIN(x."x17")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z17-B1", -- консультация (взрослые) Консультация CASE WHEN MIN(x."x17")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z17-B2", -- консультация (дети ) Консультация CASE WHEN MIN(x."x17")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z17-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN MIN(x."x17")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z17-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN MIN(x."x17")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z17-D1", -- консультация (взрослые) Иное CASE WHEN MIN(x."x17")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z17-D2", -- консультация (дети ) Иное -- + 18 CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN 1 ELSE 0 END AS "Z18-AA", -- семей CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."x01") ELSE 0 END AS "Z18-BB", -- граждан в семях CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."rE0") ELSE 0 END AS "Z18-CC", -- патронатов CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r11") ELSE 0 END AS "Z18-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r12") ELSE 0 END AS "Z18-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r21") ELSE 0 END AS "Z18-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r22") ELSE 0 END AS "Z18-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r31") ELSE 0 END AS "Z18-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r32") ELSE 0 END AS "Z18-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r41") ELSE 0 END AS "Z18-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r42") ELSE 0 END AS "Z18-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r51") ELSE 0 END AS "Z18-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r52") ELSE 0 END AS "Z18-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r61") ELSE 0 END AS "Z18-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r62") ELSE 0 END AS "Z18-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r71") ELSE 0 END AS "Z18-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r72") ELSE 0 END AS "Z18-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r81") ELSE 0 END AS "Z18-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r82") ELSE 0 END AS "Z18-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r91") ELSE 0 END AS "Z18-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."r92") ELSE 0 END AS "Z18-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."rA1") ELSE 0 END AS "Z18-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."rA2") ELSE 0 END AS "Z18-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."rB1") ELSE 0 END AS "Z18-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."rB2") ELSE 0 END AS "Z18-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."rC1") ELSE 0 END AS "Z18-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."rC2") ELSE 0 END AS "Z18-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."rD1") ELSE 0 END AS "Z18-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x03")>0 AND SUM(x."x03")<3 THEN SUM(x."rD2") ELSE 0 END AS "Z18-D2", -- консультация (дети ) Иное -- + 19 CASE WHEN SUM(x."x19")>0 THEN 1 ELSE 0 END AS "Z19-AA", -- семей CASE WHEN SUM(x."x19")>0 THEN SUM(x."x01") ELSE 0 END AS "Z19-BB", -- граждан в семях CASE WHEN SUM(x."x19")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z19-CC", -- патронатов CASE WHEN SUM(x."x19")>0 THEN SUM(x."r11") ELSE 0 END AS "Z19-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x19")>0 THEN SUM(x."r12") ELSE 0 END AS "Z19-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x19")>0 THEN SUM(x."r21") ELSE 0 END AS "Z19-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x19")>0 THEN SUM(x."r22") ELSE 0 END AS "Z19-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x19")>0 THEN SUM(x."r31") ELSE 0 END AS "Z19-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x19")>0 THEN SUM(x."r32") ELSE 0 END AS "Z19-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x19")>0 THEN SUM(x."r41") ELSE 0 END AS "Z19-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x19")>0 THEN SUM(x."r42") ELSE 0 END AS "Z19-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x19")>0 THEN SUM(x."r51") ELSE 0 END AS "Z19-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x19")>0 THEN SUM(x."r52") ELSE 0 END AS "Z19-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x19")>0 THEN SUM(x."r61") ELSE 0 END AS "Z19-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x19")>0 THEN SUM(x."r62") ELSE 0 END AS "Z19-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x19")>0 THEN SUM(x."r71") ELSE 0 END AS "Z19-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x19")>0 THEN SUM(x."r72") ELSE 0 END AS "Z19-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x19")>0 THEN SUM(x."r81") ELSE 0 END AS "Z19-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x19")>0 THEN SUM(x."r82") ELSE 0 END AS "Z19-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x19")>0 THEN SUM(x."r91") ELSE 0 END AS "Z19-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x19")>0 THEN SUM(x."r92") ELSE 0 END AS "Z19-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x19")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z19-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x19")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z19-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x19")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z19-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x19")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z19-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x19")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z19-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x19")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z19-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x19")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z19-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x19")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z19-D2", -- консультация (дети ) Иное -- + 20 CASE WHEN SUM(x."x20")>0 THEN 1 ELSE 0 END AS "Z20-AA", -- семей CASE WHEN SUM(x."x20")>0 THEN SUM(x."x01") ELSE 0 END AS "Z20-BB", -- граждан в семях CASE WHEN SUM(x."x20")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z20-CC", -- патронатов CASE WHEN SUM(x."x20")>0 THEN SUM(x."r11") ELSE 0 END AS "Z20-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x20")>0 THEN SUM(x."r12") ELSE 0 END AS "Z20-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x20")>0 THEN SUM(x."r21") ELSE 0 END AS "Z20-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x20")>0 THEN SUM(x."r22") ELSE 0 END AS "Z20-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x20")>0 THEN SUM(x."r31") ELSE 0 END AS "Z20-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x20")>0 THEN SUM(x."r32") ELSE 0 END AS "Z20-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x20")>0 THEN SUM(x."r41") ELSE 0 END AS "Z20-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x20")>0 THEN SUM(x."r42") ELSE 0 END AS "Z20-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x20")>0 THEN SUM(x."r51") ELSE 0 END AS "Z20-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x20")>0 THEN SUM(x."r52") ELSE 0 END AS "Z20-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x20")>0 THEN SUM(x."r61") ELSE 0 END AS "Z20-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x20")>0 THEN SUM(x."r62") ELSE 0 END AS "Z20-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x20")>0 THEN SUM(x."r71") ELSE 0 END AS "Z20-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x20")>0 THEN SUM(x."r72") ELSE 0 END AS "Z20-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x20")>0 THEN SUM(x."r81") ELSE 0 END AS "Z20-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x20")>0 THEN SUM(x."r82") ELSE 0 END AS "Z20-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x20")>0 THEN SUM(x."r91") ELSE 0 END AS "Z20-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x20")>0 THEN SUM(x."r92") ELSE 0 END AS "Z20-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x20")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z20-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x20")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z20-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x20")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z20-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x20")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z20-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x20")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z20-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x20")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z20-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x20")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z20-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x20")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z20-D2", -- консультация (дети ) Иное -- + 21 CASE WHEN SUM(x."x21")>0 THEN 1 ELSE 0 END AS "Z21-AA", -- семей CASE WHEN SUM(x."x21")>0 THEN SUM(x."x01") ELSE 0 END AS "Z21-BB", -- граждан в семях CASE WHEN SUM(x."x21")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z21-CC", -- патронатов CASE WHEN SUM(x."x21")>0 THEN SUM(x."r11") ELSE 0 END AS "Z21-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x21")>0 THEN SUM(x."r12") ELSE 0 END AS "Z21-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x21")>0 THEN SUM(x."r21") ELSE 0 END AS "Z21-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x21")>0 THEN SUM(x."r22") ELSE 0 END AS "Z21-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x21")>0 THEN SUM(x."r31") ELSE 0 END AS "Z21-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x21")>0 THEN SUM(x."r32") ELSE 0 END AS "Z21-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x21")>0 THEN SUM(x."r41") ELSE 0 END AS "Z21-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x21")>0 THEN SUM(x."r42") ELSE 0 END AS "Z21-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x21")>0 THEN SUM(x."r51") ELSE 0 END AS "Z21-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x21")>0 THEN SUM(x."r52") ELSE 0 END AS "Z21-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x21")>0 THEN SUM(x."r61") ELSE 0 END AS "Z21-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x21")>0 THEN SUM(x."r62") ELSE 0 END AS "Z21-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x21")>0 THEN SUM(x."r71") ELSE 0 END AS "Z21-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x21")>0 THEN SUM(x."r72") ELSE 0 END AS "Z21-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x21")>0 THEN SUM(x."r81") ELSE 0 END AS "Z21-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x21")>0 THEN SUM(x."r82") ELSE 0 END AS "Z21-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x21")>0 THEN SUM(x."r91") ELSE 0 END AS "Z21-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x21")>0 THEN SUM(x."r92") ELSE 0 END AS "Z21-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x21")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z21-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x21")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z21-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x21")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z21-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x21")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z21-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x21")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z21-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x21")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z21-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x21")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z21-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x21")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z21-D2", -- консультация (дети ) Иное -- + 22 CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN 1 ELSE 0 END AS "Z22-AA", -- семей CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."x01") ELSE 0 END AS "Z22-BB", -- граждан в семях CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z22-CC", -- патронатов CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r11") ELSE 0 END AS "Z22-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r12") ELSE 0 END AS "Z22-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r21") ELSE 0 END AS "Z22-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r22") ELSE 0 END AS "Z22-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r31") ELSE 0 END AS "Z22-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r32") ELSE 0 END AS "Z22-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r41") ELSE 0 END AS "Z22-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r42") ELSE 0 END AS "Z22-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r51") ELSE 0 END AS "Z22-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r52") ELSE 0 END AS "Z22-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r61") ELSE 0 END AS "Z22-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r62") ELSE 0 END AS "Z22-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r71") ELSE 0 END AS "Z22-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r72") ELSE 0 END AS "Z22-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r81") ELSE 0 END AS "Z22-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r82") ELSE 0 END AS "Z22-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r91") ELSE 0 END AS "Z22-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."r92") ELSE 0 END AS "Z22-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z22-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z22-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z22-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z22-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z22-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z22-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z22-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x21")>0 AND SUM(x."x03")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z22-D2", -- консультация (дети ) Иное -- + 23 CASE WHEN SUM(x."x23")>0 THEN 1 ELSE 0 END AS "Z23-AA", -- семей CASE WHEN SUM(x."x23")>0 THEN SUM(x."x01") ELSE 0 END AS "Z23-BB", -- граждан в семях CASE WHEN SUM(x."x23")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z23-CC", -- патронатов CASE WHEN SUM(x."x23")>0 THEN SUM(x."r11") ELSE 0 END AS "Z23-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x23")>0 THEN SUM(x."r12") ELSE 0 END AS "Z23-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x23")>0 THEN SUM(x."r21") ELSE 0 END AS "Z23-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x23")>0 THEN SUM(x."r22") ELSE 0 END AS "Z23-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x23")>0 THEN SUM(x."r31") ELSE 0 END AS "Z23-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x23")>0 THEN SUM(x."r32") ELSE 0 END AS "Z23-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x23")>0 THEN SUM(x."r41") ELSE 0 END AS "Z23-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x23")>0 THEN SUM(x."r42") ELSE 0 END AS "Z23-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x23")>0 THEN SUM(x."r51") ELSE 0 END AS "Z23-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x23")>0 THEN SUM(x."r52") ELSE 0 END AS "Z23-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x23")>0 THEN SUM(x."r61") ELSE 0 END AS "Z23-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x23")>0 THEN SUM(x."r62") ELSE 0 END AS "Z23-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x23")>0 THEN SUM(x."r71") ELSE 0 END AS "Z23-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x23")>0 THEN SUM(x."r72") ELSE 0 END AS "Z23-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x23")>0 THEN SUM(x."r81") ELSE 0 END AS "Z23-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x23")>0 THEN SUM(x."r82") ELSE 0 END AS "Z23-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x23")>0 THEN SUM(x."r91") ELSE 0 END AS "Z23-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x23")>0 THEN SUM(x."r92") ELSE 0 END AS "Z23-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x23")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z23-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x23")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z23-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x23")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z23-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x23")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z23-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x23")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z23-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x23")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z23-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x23")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z23-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x23")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z23-D2", -- консультация (дети ) Иное -- + 24 CASE WHEN SUM(x."x24")>0 THEN 1 ELSE 0 END AS "Z24-AA", -- семей CASE WHEN SUM(x."x24")>0 THEN SUM(x."x01") ELSE 0 END AS "Z24-BB", -- граждан в семях CASE WHEN SUM(x."x24")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z24-CC", -- патронатов CASE WHEN SUM(x."x24")>0 THEN SUM(x."r11") ELSE 0 END AS "Z24-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x24")>0 THEN SUM(x."r12") ELSE 0 END AS "Z24-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x24")>0 THEN SUM(x."r21") ELSE 0 END AS "Z24-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x24")>0 THEN SUM(x."r22") ELSE 0 END AS "Z24-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x24")>0 THEN SUM(x."r31") ELSE 0 END AS "Z24-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x24")>0 THEN SUM(x."r32") ELSE 0 END AS "Z24-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x24")>0 THEN SUM(x."r41") ELSE 0 END AS "Z24-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x24")>0 THEN SUM(x."r42") ELSE 0 END AS "Z24-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x24")>0 THEN SUM(x."r51") ELSE 0 END AS "Z24-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x24")>0 THEN SUM(x."r52") ELSE 0 END AS "Z24-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x24")>0 THEN SUM(x."r61") ELSE 0 END AS "Z24-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x24")>0 THEN SUM(x."r62") ELSE 0 END AS "Z24-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x24")>0 THEN SUM(x."r71") ELSE 0 END AS "Z24-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x24")>0 THEN SUM(x."r72") ELSE 0 END AS "Z24-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x24")>0 THEN SUM(x."r81") ELSE 0 END AS "Z24-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x24")>0 THEN SUM(x."r82") ELSE 0 END AS "Z24-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x24")>0 THEN SUM(x."r91") ELSE 0 END AS "Z24-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x24")>0 THEN SUM(x."r92") ELSE 0 END AS "Z24-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x24")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z24-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x24")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z24-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x24")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z24-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x24")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z24-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x24")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z24-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x24")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z24-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x24")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z24-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x24")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z24-D2", -- консультация (дети ) Иное -- + 25 CASE WHEN SUM(x."x25")>0 THEN 1 ELSE 0 END AS "Z25-AA", -- семей CASE WHEN SUM(x."x25")>0 THEN SUM(x."x01") ELSE 0 END AS "Z25-BB", -- граждан в семях CASE WHEN SUM(x."x25")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z25-CC", -- патронатов CASE WHEN SUM(x."x25")>0 THEN SUM(x."r11") ELSE 0 END AS "Z25-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x25")>0 THEN SUM(x."r12") ELSE 0 END AS "Z25-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x25")>0 THEN SUM(x."r21") ELSE 0 END AS "Z25-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x25")>0 THEN SUM(x."r22") ELSE 0 END AS "Z25-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x25")>0 THEN SUM(x."r31") ELSE 0 END AS "Z25-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x25")>0 THEN SUM(x."r32") ELSE 0 END AS "Z25-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x25")>0 THEN SUM(x."r41") ELSE 0 END AS "Z25-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x25")>0 THEN SUM(x."r42") ELSE 0 END AS "Z25-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x25")>0 THEN SUM(x."r51") ELSE 0 END AS "Z25-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x25")>0 THEN SUM(x."r52") ELSE 0 END AS "Z25-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x25")>0 THEN SUM(x."r61") ELSE 0 END AS "Z25-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x25")>0 THEN SUM(x."r62") ELSE 0 END AS "Z25-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x25")>0 THEN SUM(x."r71") ELSE 0 END AS "Z25-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x25")>0 THEN SUM(x."r72") ELSE 0 END AS "Z25-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x25")>0 THEN SUM(x."r81") ELSE 0 END AS "Z25-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x25")>0 THEN SUM(x."r82") ELSE 0 END AS "Z25-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x25")>0 THEN SUM(x."r91") ELSE 0 END AS "Z25-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x25")>0 THEN SUM(x."r92") ELSE 0 END AS "Z25-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x25")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z25-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x25")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z25-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x25")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z25-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x25")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z25-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x25")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z25-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x25")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z25-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x25")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z25-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x25")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z25-D2", -- консультация (дети ) Иное -- + 26 CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN 1 ELSE 0 END AS "Z26-AA", -- семей CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."x01") ELSE 0 END AS "Z26-BB", -- граждан в семях CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z26-CC", -- патронатов CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r11") ELSE 0 END AS "Z26-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r12") ELSE 0 END AS "Z26-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r21") ELSE 0 END AS "Z26-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r22") ELSE 0 END AS "Z26-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r31") ELSE 0 END AS "Z26-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r32") ELSE 0 END AS "Z26-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r41") ELSE 0 END AS "Z26-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r42") ELSE 0 END AS "Z26-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r51") ELSE 0 END AS "Z26-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r52") ELSE 0 END AS "Z26-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r61") ELSE 0 END AS "Z26-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r62") ELSE 0 END AS "Z26-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r71") ELSE 0 END AS "Z26-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r72") ELSE 0 END AS "Z26-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r81") ELSE 0 END AS "Z26-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r82") ELSE 0 END AS "Z26-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r91") ELSE 0 END AS "Z26-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."r92") ELSE 0 END AS "Z26-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z26-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z26-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z26-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z26-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z26-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z26-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z26-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x16")>0 AND SUM(x."x03")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z26-D2", -- консультация (дети ) Иное -- + 27 CASE WHEN SUM(x."x27")>0 THEN 1 ELSE 0 END AS "Z27-AA", -- семей CASE WHEN SUM(x."x27")>0 THEN SUM(x."x01") ELSE 0 END AS "Z27-BB", -- граждан в семях CASE WHEN SUM(x."x27")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z27-CC", -- патронатов CASE WHEN SUM(x."x27")>0 THEN SUM(x."r11") ELSE 0 END AS "Z27-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x27")>0 THEN SUM(x."r12") ELSE 0 END AS "Z27-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x27")>0 THEN SUM(x."r21") ELSE 0 END AS "Z27-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x27")>0 THEN SUM(x."r22") ELSE 0 END AS "Z27-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x27")>0 THEN SUM(x."r31") ELSE 0 END AS "Z27-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x27")>0 THEN SUM(x."r32") ELSE 0 END AS "Z27-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x27")>0 THEN SUM(x."r41") ELSE 0 END AS "Z27-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x27")>0 THEN SUM(x."r42") ELSE 0 END AS "Z27-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x27")>0 THEN SUM(x."r51") ELSE 0 END AS "Z27-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x27")>0 THEN SUM(x."r52") ELSE 0 END AS "Z27-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x27")>0 THEN SUM(x."r61") ELSE 0 END AS "Z27-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x27")>0 THEN SUM(x."r62") ELSE 0 END AS "Z27-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x27")>0 THEN SUM(x."r71") ELSE 0 END AS "Z27-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x27")>0 THEN SUM(x."r72") ELSE 0 END AS "Z27-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x27")>0 THEN SUM(x."r81") ELSE 0 END AS "Z27-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x27")>0 THEN SUM(x."r82") ELSE 0 END AS "Z27-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x27")>0 THEN SUM(x."r91") ELSE 0 END AS "Z27-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x27")>0 THEN SUM(x."r92") ELSE 0 END AS "Z27-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x27")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z27-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x27")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z27-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x27")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z27-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x27")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z27-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x27")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z27-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x27")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z27-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x27")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z27-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x27")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z27-D2", -- консультация (дети ) Иное -- + 28 CASE WHEN SUM(x."x03")>0 THEN 1 ELSE 0 END AS "Z28-AA", -- семей CASE WHEN SUM(x."x03")>0 THEN SUM(x."x01") ELSE 0 END AS "Z28-BB", -- граждан в семях CASE WHEN SUM(x."x03")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z28-CC", -- патронатов CASE WHEN SUM(x."x03")>0 THEN SUM(x."r11") ELSE 0 END AS "Z28-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x03")>0 THEN SUM(x."r12") ELSE 0 END AS "Z28-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x03")>0 THEN SUM(x."r21") ELSE 0 END AS "Z28-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x03")>0 THEN SUM(x."r22") ELSE 0 END AS "Z28-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x03")>0 THEN SUM(x."r31") ELSE 0 END AS "Z28-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x03")>0 THEN SUM(x."r32") ELSE 0 END AS "Z28-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x03")>0 THEN SUM(x."r41") ELSE 0 END AS "Z28-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x03")>0 THEN SUM(x."r42") ELSE 0 END AS "Z28-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x03")>0 THEN SUM(x."r51") ELSE 0 END AS "Z28-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x03")>0 THEN SUM(x."r52") ELSE 0 END AS "Z28-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x03")>0 THEN SUM(x."r61") ELSE 0 END AS "Z28-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x03")>0 THEN SUM(x."r62") ELSE 0 END AS "Z28-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x03")>0 THEN SUM(x."r71") ELSE 0 END AS "Z28-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x03")>0 THEN SUM(x."r72") ELSE 0 END AS "Z28-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x03")>0 THEN SUM(x."r81") ELSE 0 END AS "Z28-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x03")>0 THEN SUM(x."r82") ELSE 0 END AS "Z28-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x03")>0 THEN SUM(x."r91") ELSE 0 END AS "Z28-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x03")>0 THEN SUM(x."r92") ELSE 0 END AS "Z28-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x03")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z28-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x03")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z28-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x03")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z28-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x03")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z28-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x03")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z28-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x03")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z28-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x03")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z28-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x03")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z28-D2", -- консультация (дети ) Иное -- + 29 CASE WHEN SUM(x."x29")>0 THEN 1 ELSE 0 END AS "Z29-AA", -- семей CASE WHEN SUM(x."x29")>0 THEN SUM(x."x01") ELSE 0 END AS "Z29-BB", -- граждан в семях CASE WHEN SUM(x."x29")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z29-CC", -- патронатов CASE WHEN SUM(x."x29")>0 THEN SUM(x."r11") ELSE 0 END AS "Z29-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x29")>0 THEN SUM(x."r12") ELSE 0 END AS "Z29-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x29")>0 THEN SUM(x."r21") ELSE 0 END AS "Z29-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x29")>0 THEN SUM(x."r22") ELSE 0 END AS "Z29-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x29")>0 THEN SUM(x."r31") ELSE 0 END AS "Z29-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x29")>0 THEN SUM(x."r32") ELSE 0 END AS "Z29-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x29")>0 THEN SUM(x."r41") ELSE 0 END AS "Z29-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x29")>0 THEN SUM(x."r42") ELSE 0 END AS "Z29-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x29")>0 THEN SUM(x."r51") ELSE 0 END AS "Z29-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x29")>0 THEN SUM(x."r52") ELSE 0 END AS "Z29-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x29")>0 THEN SUM(x."r61") ELSE 0 END AS "Z29-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x29")>0 THEN SUM(x."r62") ELSE 0 END AS "Z29-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x29")>0 THEN SUM(x."r71") ELSE 0 END AS "Z29-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x29")>0 THEN SUM(x."r72") ELSE 0 END AS "Z29-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x29")>0 THEN SUM(x."r81") ELSE 0 END AS "Z29-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x29")>0 THEN SUM(x."r82") ELSE 0 END AS "Z29-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x29")>0 THEN SUM(x."r91") ELSE 0 END AS "Z29-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x29")>0 THEN SUM(x."r92") ELSE 0 END AS "Z29-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x29")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z29-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x29")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z29-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x29")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z29-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x29")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z29-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x29")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z29-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x29")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z29-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x29")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z29-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x29")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z29-D2", -- консультация (дети ) Иное -- + 30 CASE WHEN SUM(x."x30")>0 THEN 1 ELSE 0 END AS "Z30-AA", -- семей CASE WHEN SUM(x."x30")>0 THEN SUM(x."x01") ELSE 0 END AS "Z30-BB", -- граждан в семях CASE WHEN SUM(x."x30")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z30-CC", -- патронатов CASE WHEN SUM(x."x30")>0 THEN SUM(x."r11") ELSE 0 END AS "Z30-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x30")>0 THEN SUM(x."r12") ELSE 0 END AS "Z30-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x30")>0 THEN SUM(x."r21") ELSE 0 END AS "Z30-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x30")>0 THEN SUM(x."r22") ELSE 0 END AS "Z30-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x30")>0 THEN SUM(x."r31") ELSE 0 END AS "Z30-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x30")>0 THEN SUM(x."r32") ELSE 0 END AS "Z30-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x30")>0 THEN SUM(x."r41") ELSE 0 END AS "Z30-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x30")>0 THEN SUM(x."r42") ELSE 0 END AS "Z30-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x30")>0 THEN SUM(x."r51") ELSE 0 END AS "Z30-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x30")>0 THEN SUM(x."r52") ELSE 0 END AS "Z30-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x30")>0 THEN SUM(x."r61") ELSE 0 END AS "Z30-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x30")>0 THEN SUM(x."r62") ELSE 0 END AS "Z30-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x30")>0 THEN SUM(x."r71") ELSE 0 END AS "Z30-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x30")>0 THEN SUM(x."r72") ELSE 0 END AS "Z30-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x30")>0 THEN SUM(x."r81") ELSE 0 END AS "Z30-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x30")>0 THEN SUM(x."r82") ELSE 0 END AS "Z30-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x30")>0 THEN SUM(x."r91") ELSE 0 END AS "Z30-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x30")>0 THEN SUM(x."r92") ELSE 0 END AS "Z30-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x30")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z30-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x30")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z30-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x30")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z30-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x30")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z30-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x30")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z30-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x30")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z30-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x30")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z30-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x30")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z30-D2", -- консультация (дети ) Иное -- + 31 CASE WHEN SUM(x."x31")>0 THEN 1 ELSE 0 END AS "Z31-AA", -- семей CASE WHEN SUM(x."x31")>0 THEN SUM(x."x01") ELSE 0 END AS "Z31-BB", -- граждан в семях CASE WHEN SUM(x."x31")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z31-CC", -- патронатов CASE WHEN SUM(x."x31")>0 THEN SUM(x."r11") ELSE 0 END AS "Z31-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x31")>0 THEN SUM(x."r12") ELSE 0 END AS "Z31-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x31")>0 THEN SUM(x."r21") ELSE 0 END AS "Z31-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x31")>0 THEN SUM(x."r22") ELSE 0 END AS "Z31-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x31")>0 THEN SUM(x."r31") ELSE 0 END AS "Z31-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x31")>0 THEN SUM(x."r32") ELSE 0 END AS "Z31-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x31")>0 THEN SUM(x."r41") ELSE 0 END AS "Z31-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x31")>0 THEN SUM(x."r42") ELSE 0 END AS "Z31-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x31")>0 THEN SUM(x."r51") ELSE 0 END AS "Z31-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x31")>0 THEN SUM(x."r52") ELSE 0 END AS "Z31-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x31")>0 THEN SUM(x."r61") ELSE 0 END AS "Z31-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x31")>0 THEN SUM(x."r62") ELSE 0 END AS "Z31-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x31")>0 THEN SUM(x."r71") ELSE 0 END AS "Z31-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x31")>0 THEN SUM(x."r72") ELSE 0 END AS "Z31-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x31")>0 THEN SUM(x."r81") ELSE 0 END AS "Z31-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x31")>0 THEN SUM(x."r82") ELSE 0 END AS "Z31-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x31")>0 THEN SUM(x."r91") ELSE 0 END AS "Z31-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x31")>0 THEN SUM(x."r92") ELSE 0 END AS "Z31-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x31")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z31-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x31")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z31-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x31")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z31-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x31")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z31-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x31")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z31-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x31")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z31-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x31")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z31-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x31")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z31-D2", -- консультация (дети ) Иное -- + 32 CASE WHEN SUM(x."x32")>0 THEN 1 ELSE 0 END AS "Z32-AA", -- семей CASE WHEN SUM(x."x32")>0 THEN SUM(x."x01") ELSE 0 END AS "Z32-BB", -- граждан в семях CASE WHEN SUM(x."x32")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z32-CC", -- патронатов CASE WHEN SUM(x."x32")>0 THEN SUM(x."r11") ELSE 0 END AS "Z32-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x32")>0 THEN SUM(x."r12") ELSE 0 END AS "Z32-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x32")>0 THEN SUM(x."r21") ELSE 0 END AS "Z32-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x32")>0 THEN SUM(x."r22") ELSE 0 END AS "Z32-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x32")>0 THEN SUM(x."r31") ELSE 0 END AS "Z32-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x32")>0 THEN SUM(x."r32") ELSE 0 END AS "Z32-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x32")>0 THEN SUM(x."r41") ELSE 0 END AS "Z32-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x32")>0 THEN SUM(x."r42") ELSE 0 END AS "Z32-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x32")>0 THEN SUM(x."r51") ELSE 0 END AS "Z32-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x32")>0 THEN SUM(x."r52") ELSE 0 END AS "Z32-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x32")>0 THEN SUM(x."r61") ELSE 0 END AS "Z32-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x32")>0 THEN SUM(x."r62") ELSE 0 END AS "Z32-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x32")>0 THEN SUM(x."r71") ELSE 0 END AS "Z32-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x32")>0 THEN SUM(x."r72") ELSE 0 END AS "Z32-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x32")>0 THEN SUM(x."r81") ELSE 0 END AS "Z32-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x32")>0 THEN SUM(x."r82") ELSE 0 END AS "Z32-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x32")>0 THEN SUM(x."r91") ELSE 0 END AS "Z32-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x32")>0 THEN SUM(x."r92") ELSE 0 END AS "Z32-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x32")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z32-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x32")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z32-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x32")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z32-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x32")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z32-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x32")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z32-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x32")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z32-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x32")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z32-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x32")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z32-D2", -- консультация (дети ) Иное -- + 33 CASE WHEN SUM(x."x33")>0 THEN 1 ELSE 0 END AS "Z33-AA", -- семей CASE WHEN SUM(x."x33")>0 THEN SUM(x."x01") ELSE 0 END AS "Z33-BB", -- граждан в семях CASE WHEN SUM(x."x33")>0 THEN SUM(x."rE0") ELSE 0 END AS "Z33-CC", -- патронатов CASE WHEN SUM(x."x33")>0 THEN SUM(x."r11") ELSE 0 END AS "Z33-11", -- консультация (взрослые) Психлологическая CASE WHEN SUM(x."x33")>0 THEN SUM(x."r12") ELSE 0 END AS "Z33-12", -- консультация (дети ) Психлологическая CASE WHEN SUM(x."x33")>0 THEN SUM(x."r21") ELSE 0 END AS "Z33-21", -- консультация (взрослые) Педагогическая CASE WHEN SUM(x."x33")>0 THEN SUM(x."r22") ELSE 0 END AS "Z33-22", -- консультация (дети ) Педагогическая CASE WHEN SUM(x."x33")>0 THEN SUM(x."r31") ELSE 0 END AS "Z33-31", -- консультация (взрослые) Юридическая CASE WHEN SUM(x."x33")>0 THEN SUM(x."r32") ELSE 0 END AS "Z33-32", -- консультация (дети ) Юридическая CASE WHEN SUM(x."x33")>0 THEN SUM(x."r41") ELSE 0 END AS "Z33-41", -- консультация (взрослые) Индивидуально-коррекционная CASE WHEN SUM(x."x33")>0 THEN SUM(x."r42") ELSE 0 END AS "Z33-42", -- консультация (дети ) Индивидуально-коррекционная CASE WHEN SUM(x."x33")>0 THEN SUM(x."r51") ELSE 0 END AS "Z33-51", -- консультация (взрослые) Групповая-коррекционная CASE WHEN SUM(x."x33")>0 THEN SUM(x."r52") ELSE 0 END AS "Z33-52", -- консультация (дети ) Групповая-коррекционная CASE WHEN SUM(x."x33")>0 THEN SUM(x."r61") ELSE 0 END AS "Z33-61", -- консультация (взрослые) Научно-методическая CASE WHEN SUM(x."x33")>0 THEN SUM(x."r62") ELSE 0 END AS "Z33-62", -- консультация (дети ) Научно-методическая CASE WHEN SUM(x."x33")>0 THEN SUM(x."r71") ELSE 0 END AS "Z33-71", -- консультация (взрослые) Информационная CASE WHEN SUM(x."x33")>0 THEN SUM(x."r72") ELSE 0 END AS "Z33-72", -- консультация (дети ) Информационная CASE WHEN SUM(x."x33")>0 THEN SUM(x."r81") ELSE 0 END AS "Z33-81", -- консультация (взрослые) Методическая CASE WHEN SUM(x."x33")>0 THEN SUM(x."r82") ELSE 0 END AS "Z33-82", -- консультация (дети ) Методическая CASE WHEN SUM(x."x33")>0 THEN SUM(x."r91") ELSE 0 END AS "Z33-91", -- консультация (взрослые) Иное CASE WHEN SUM(x."x33")>0 THEN SUM(x."r92") ELSE 0 END AS "Z33-92", -- консультация (дети ) Иное CASE WHEN SUM(x."x33")>0 THEN SUM(x."rA1") ELSE 0 END AS "Z33-A1", -- консультация (взрослые) Группа CASE WHEN SUM(x."x33")>0 THEN SUM(x."rA2") ELSE 0 END AS "Z33-A2", -- консультация (дети ) Группа CASE WHEN SUM(x."x33")>0 THEN SUM(x."rB1") ELSE 0 END AS "Z33-B1", -- консультация (взрослые) Консультация CASE WHEN SUM(x."x33")>0 THEN SUM(x."rB2") ELSE 0 END AS "Z33-B2", -- консультация (дети ) Консультация CASE WHEN SUM(x."x33")>0 THEN SUM(x."rC1") ELSE 0 END AS "Z33-C1", -- консультация (взрослые) Индивидуальное занятие CASE WHEN SUM(x."x33")>0 THEN SUM(x."rC2") ELSE 0 END AS "Z33-C2", -- консультация (дети ) Индивидуальное занятие CASE WHEN SUM(x."x33")>0 THEN SUM(x."rD1") ELSE 0 END AS "Z33-D1", -- консультация (взрослые) Иное CASE WHEN SUM(x."x33")>0 THEN SUM(x."rD2") ELSE 0 END AS "Z33-D2" -- консультация (дети ) Иное FROM ( SELECT x."Id", x."FamilyId", x."Age", x."Sex", x."IsChild", x."IsParent", x."x01",x."x02",x."x03",x."x04",x."x05", x."x06",x."x07",x."x08",x."x09",x."x10", x."x11",x."x12",x."x13",x."x14",x."x15", x."x16",x."x17",x."x19",x."x20",x."x21", x."x23",x."x24",x."x25",x."x26",x."x27", x."x29",x."x30",x."x31",x."x32",x."x33", SUM(x."r11") AS "r11", SUM(x."r12") AS "r12", SUM(x."r21") AS "r21", SUM(x."r22") AS "r22", SUM(x."r31") AS "r31", SUM(x."r32") AS "r32", SUM(x."r41") AS "r41", SUM(x."r42") AS "r42", SUM(x."r51") AS "r51", SUM(x."r52") AS "r52", SUM(x."r61") AS "r61", SUM(x."r62") AS "r62", SUM(x."r71") AS "r71", SUM(x."r72") AS "r72", SUM(x."r81") AS "r81", SUM(x."r82") AS "r82", SUM(x."r91") AS "r91", SUM(x."r92") AS "r92", SUM(x."rA1") AS "rA1", SUM(x."rA2") AS "rA2", SUM(x."rB1") AS "rB1", SUM(x."rB2") AS "rB2", SUM(x."rC1") AS "rC1", SUM(x."rC2") AS "rC2", SUM(x."rD1") AS "rD1", SUM(x."rD2") AS "rD2", SUM(x."rE0") AS "rE0" FROM ( SELECT f.*, CASE WHEN COALESCE(pr1."Rubrica",0) = 1020 AND f."IsChild"=0 THEN 1 ELSE 0 END AS "r11", CASE WHEN COALESCE(pr1."Rubrica",0) = 1020 AND f."IsChild">0 THEN 1 ELSE 0 END AS "r12", CASE WHEN COALESCE(pr1."Rubrica",0) = 1022 AND f."IsChild"=0 THEN 1 ELSE 0 END AS "r21", CASE WHEN COALESCE(pr1."Rubrica",0) = 1022 AND f."IsChild">0 THEN 1 ELSE 0 END AS "r22", CASE WHEN COALESCE(pr1."Rubrica",0) = 1025 AND f."IsChild"=0 THEN 1 ELSE 0 END AS "r31", CASE WHEN COALESCE(pr1."Rubrica",0) = 1025 AND f."IsChild">0 THEN 1 ELSE 0 END AS "r32", CASE WHEN COALESCE(pr1."Rubrica",0) = 1014 AND f."IsChild"=0 THEN 1 ELSE 0 END AS "r41", CASE WHEN COALESCE(pr1."Rubrica",0) = 1014 AND f."IsChild">0 THEN 1 ELSE 0 END AS "r42", CASE WHEN COALESCE(pr1."Rubrica",0) = 1013 AND f."IsChild"=0 THEN 1 ELSE 0 END AS "r51", CASE WHEN COALESCE(pr1."Rubrica",0) = 1013 AND f."IsChild">0 THEN 1 ELSE 0 END AS "r52", CASE WHEN COALESCE(pr1."Rubrica",0) = 1019 AND f."IsChild"=0 THEN 1 ELSE 0 END AS "r61", CASE WHEN COALESCE(pr1."Rubrica",0) = 1019 AND f."IsChild">0 THEN 1 ELSE 0 END AS "r62", CASE WHEN COALESCE(pr1."Rubrica",0) = 1015 AND f."IsChild"=0 THEN 1 ELSE 0 END AS "r71", CASE WHEN COALESCE(pr1."Rubrica",0) = 1015 AND f."IsChild">0 THEN 1 ELSE 0 END AS "r72", CASE WHEN COALESCE(pr1."Rubrica",0) = 1018 AND f."IsChild"=0 THEN 1 ELSE 0 END AS "r81", CASE WHEN COALESCE(pr1."Rubrica",0) = 1018 AND f."IsChild">0 THEN 1 ELSE 0 END AS "r82", CASE WHEN COALESCE(pr1."Rubrica",0) NOT IN (1013,1014,1015,1019,1018,1020,1022,1025) AND f."IsChild"=0 THEN 1 ELSE 0 END AS "r91", CASE WHEN COALESCE(pr1."Rubrica",0) NOT IN (1013,1014,1015,1019,1018,1020,1022,1025) AND f."IsChild">0 THEN 1 ELSE 0 END AS "r92", CASE WHEN COALESCE(pr2."Rubrica",0) = 1211 AND f."IsChild"=0 THEN 1 ELSE 0 END AS "rA1", CASE WHEN COALESCE(pr2."Rubrica",0) = 1211 AND f."IsChild">0 THEN 1 ELSE 0 END AS "rA2", CASE WHEN COALESCE(pr2."Rubrica",0) IN (1047,1049) AND f."IsChild"=0 THEN 1 ELSE 0 END AS "rB1", CASE WHEN COALESCE(pr2."Rubrica",0) IN (1047,1049) AND f."IsChild">0 THEN 1 ELSE 0 END AS "rB2", CASE WHEN COALESCE(pr2."Rubrica",0) = 1044 AND f."IsChild"=0 THEN 1 ELSE 0 END AS "rC1", CASE WHEN COALESCE(pr2."Rubrica",0) = 1044 AND f."IsChild">0 THEN 1 ELSE 0 END AS "rC2", CASE WHEN COALESCE(pr2."Rubrica",0) NOT IN (1211,1047,1049,1044) AND f."IsChild"=0 THEN 1 ELSE 0 END AS "rD1", CASE WHEN COALESCE(pr2."Rubrica",0) NOT IN (1211,1047,1049,1044) AND f."IsChild">0 THEN 1 ELSE 0 END AS "rD2", CASE WHEN COALESCE(pr3."Rubrica",0) > 0 THEN 1 ELSE 0 END AS "rE0" FROM "FamilyOnPeriod"('2015-01-01','2015-12-31') AS f LEFT JOIN "Service2Clients" AS sc ON sc."Client" = f."Id" LEFT JOIN "Service" AS s ON s."Id" = sc."Service" AND s."Date" BETWEEN '2015-01-01' AND '2015-12-31' LEFT JOIN "Points2Rubrica" AS pr1 ON pr1."Point" = s."Id" AND pr1."System" & 8 = 8 AND pr1."Rubrica" IN (SELECT r."Id" FROM "Rubricator" AS r WHERE r."GroupId" = 123) LEFT JOIN "Points2Rubrica" AS pr2 ON pr2."Point" = s."Id" AND pr2."System" & 8 = 8 AND pr2."Rubrica" IN (SELECT r."Id" FROM "Rubricator" AS r WHERE r."GroupId" = 118) LEFT JOIN "Points2Rubrica" AS pr3 ON pr3."Point" = f."Id" AND pr3."System" & 2 = 2 AND pr3."Rubrica" IN (SELECT r."Id" FROM "Rubricator" AS r WHERE r."GroupId" = 142) ) AS x GROUP BY x."Id", x."FamilyId", x."Age", x."Sex", x."IsChild", x."IsParent", x."x01",x."x02",x."x03",x."x04",x."x05", x."x06",x."x07",x."x08",x."x09",x."x10", x."x11",x."x12",x."x13",x."x14",x."x15", x."x16",x."x17",x."x19",x."x20",x."x21", x."x23",x."x24",x."x25",x."x26",x."x27", x."x29",x."x30",x."x31",x."x32",x."x33" ) AS x GROUP BY x."FamilyId" ) AS y