{"id":267170,"date":"2015-10-30T15:56:03","date_gmt":"2015-10-30T12:56:03","guid":{"rendered":"http:\/\/savepearlharbor.com\/?p=267170"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=267170","title":{"rendered":"PostgreSQL 9.5: \u0447\u0442\u043e \u043d\u043e\u0432\u043e\u0433\u043e? \u0427\u0430\u0441\u0442\u044c 3. GROUPING SETS, CUBE, ROLLUP"},"content":{"rendered":"

\u041f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u0435\u043c \u0437\u043d\u0430\u043a\u043e\u043c\u0438\u0442\u044c\u0441\u044f \u0441 \u043d\u043e\u0432\u044b\u043c\u0438 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044f\u043c\u0438 \u0432 PostgreSQL 9.5.
\u0427\u0430\u0441\u0442\u044c 1. INSERT\u2026 ON CONFLICT DO NOTHING\/UPDATE \u0438 ROW LEVEL SECURITY<\/a>
\u0427\u0430\u0441\u0442\u044c 2. TABLESAMPLE<\/a>
\u0421\u0435\u0433\u043e\u0434\u043d\u044f \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0435 \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0438 \u0432 \u043e\u0434\u043d\u043e\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435. \u042d\u0442\u0430 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0431\u044b\u043b\u0430 \u043e\u043f\u0438\u0441\u0430\u043d\u0430 \u0435\u0449\u0435 \u0432 \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u0435 SQL-99. \u0415\u0451 \u0443\u0434\u043e\u0431\u043d\u043e \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u0442\u044c \u0432 \u0442\u043e\u043c \u0441\u043b\u0443\u0447\u0430\u0435, \u0435\u0441\u043b\u0438 \u0432\u0430\u043c \u043d\u0443\u0436\u043d\u043e \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043a \u043e\u0434\u043d\u043e\u0439 \u0438 \u0442\u043e\u0439 \u0436\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u0435, \u043e\u0442\u043b\u0438\u0447\u0430\u044e\u0449\u0438\u0445\u0441\u044f \u0442\u043e\u043b\u044c\u043a\u043e \u0443\u0441\u043b\u043e\u0432\u0438\u0435\u043c \u0432 GROUP BY<\/b>. \u0414\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u043c\u043e\u0434\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440\u044b GROUPING SETS, ROLLUP, CUBE<\/b> \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u044e\u0442\u0441\u044f \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430 \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0438 \u043f\u043e\u0441\u043b\u0435 \u043a\u043b\u044e\u0447\u0435\u0432\u043e\u0433\u043e \u0441\u043b\u043e\u0432\u0430 GROUP BY<\/b>.
\u0414\u0430\u0432\u0430\u0439\u0442\u0435 \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043f\u043e\u0431\u043b\u0438\u0436\u0435, \u043a\u0430\u043a \u044d\u0442\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442.
<\/a>
\u041f\u0443\u0441\u0442\u044c \u0443 \u043d\u0430\u0441 \u0435\u0441\u0442\u044c \u0441\u0445\u0435\u043c\u0430, \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u0435\u0441\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0435 \u043e \u043f\u043b\u0430\u0442\u0435\u0436\u0430\u0445, \u043a\u0430\u0436\u0434\u044b\u0439 \u043f\u043b\u0430\u0442\u0435\u0436 \u0438\u043c\u0435\u0435\u0442 \u0442\u0438\u043f, \u0433\u043e\u0440\u043e\u0434, \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u043c \u044d\u0442\u043e\u0442 \u043f\u043b\u0430\u0442\u0435\u0436 \u0431\u044b\u043b \u0441\u043e\u0432\u0435\u0440\u0448\u0435\u043d \u0438 \u0441\u0443\u043c\u043c\u0443 \u043f\u043b\u0430\u0442\u0435\u0436\u0430. \u0413\u043e\u0440\u043e\u0434 \u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u044c\u043d\u043e \u0438\u043c\u0435\u0435\u0442 \u0441\u0442\u0440\u0430\u043d\u0443 \u0438, \u043e\u043f\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e, \u0440\u0435\u0433\u0438\u043e\u043d. \u041d\u0438\u0436\u0435 \u043f\u0440\u0438\u0432\u0435\u0434\u0435\u043d\u044b \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0442\u0430\u043a\u043e\u0439 \u0441\u0445\u0435\u043c\u044b \u0438 \u0437\u0430\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0435\u0451 \u0434\u0430\u043d\u043d\u044b\u043c\u0438. <\/p>\n

\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0441\u0445\u0435\u043c\u044b<\/b><\/p>\n
\n
DROP TABLE IF EXISTS payment; DROP TABLE IF EXISTS payment_type; DROP TABLE IF EXISTS city; DROP TABLE IF EXISTS state; DROP TABLE IF EXISTS country;  CREATE TABLE country (   id   SERIAL PRIMARY KEY,   name VARCHAR NOT NULL );   CREATE TABLE state (   id         SERIAL PRIMARY KEY,   name       VARCHAR NOT NULL,   country_id INT REFERENCES country (id) );   CREATE TABLE city (   id         SERIAL PRIMARY KEY,   name       VARCHAR NOT NULL,   state_id   INT     NULL REFERENCES state (id),   country_id INT     NOT NULL REFERENCES country (id),   population BIGINT  NOT NULL );   CREATE TABLE payment_type (   id   SERIAL PRIMARY KEY,   name VARCHAR NOT NULL );  CREATE TABLE payment (   id              BIGSERIAL PRIMARY KEY,   payment_type_id INT            NOT NULL REFERENCES payment_type (id),   city_id         INT            NOT NULL REFERENCES city (id),   amount          NUMERIC(10, 2) NOT NULL );  INSERT INTO country (name) VALUES ('Russia'), ('Ukraine');  INSERT INTO state (name, country_id) VALUES ('Moscow region', 1), ('Samara region', 1), ('Kursk region', 1), ('Tatarstan', 1),   ('Kiev region', 2), ('Lugansk region', 2), ('Lvov region', 2), ('Odessa region', 2);   \u2013- \u041c\u043e\u0441\u043a\u0432\u0430 \u0438 \u041a\u0438\u0435\u0432 \u043d\u0435 \u044f\u0432\u043b\u044f\u044e\u0442\u0441\u044f \u0447\u0430\u0441\u0442\u044c\u044e \u041c\u043e\u0441\u043a\u043e\u0432\u0441\u043a\u043e\u0439 \u0438 \u041a\u0438\u0435\u0432\u0441\u043a\u043e\u0439 \u043e\u0431\u043b\u0430\u0441\u0442\u0438, \u0441\u043e\u0433\u043b\u0430\u0441\u043d\u043e \u0437\u0430\u043a\u043e\u043d\u0430\u043c \u0420\u0424 \u0438 \u0423\u043a\u0440\u0430\u0438\u043d\u044b INSERT INTO city (name, state_id, country_id, population) VALUES ('Moscow', NULL, 1, 12197596), ('Dubna', 1, 1, 75176),   ('Samara', 2, 1, 1171820), ('Tolyatti', 2, 1, 719646), ('Syzran', 2, 1, 175222), ('Novokuybyshevsk', 2, 1, 105007),   ('Kursk', 3, 1, 435117),   ('Kazan', 4, 1, 1205651),   ('Kiev', NULL, 2, 2888470), ('Irpen', 5, 2, 39972), ('Borispol', 5, 2, 60102), ('Belaya Tserkov', 5, 2, 211205),   ('Lugansk', 6, 2, 417990), ('Lisichansk', 6, 2, 103459), ('Severodonetsk', 6, 2, 108899), ('Popasnaya', 6, 2, 21765),   ('Lvov', 7, 2, 729038), ('Drogobych', 7, 2, 76866),   ('Odessa', 8, 2, 1017022), ('Izmail', 8, 2, 72501);  INSERT INTO payment_type (name) VALUES ('Online'), ('Box office'), ('Terminal');   INSERT INTO payment (payment_type_id, city_id, amount)   SELECT     ceil(random() * 3),     ceil(random() * 20),     trunc(cast(random() * 10000 AS NUMERIC), 2)   FROM generate_series(1, 10000); <\/code><\/pre>\n
  <\/div>\n<\/div>\n
  \u041f\u0440\u0435\u0434\u043f\u043e\u043b\u043e\u0436\u0438\u043c, \u0447\u0442\u043e \u043c\u044b \u0445\u043e\u0442\u0438\u043c \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0443 \u043e \u0441\u0443\u043c\u043c\u0435 \u043f\u043b\u0430\u0442\u0435\u0436\u0435\u0439 \u0432 \u043a\u0430\u0436\u0434\u043e\u043c \u0433\u043e\u0440\u043e\u0434\u0435 \u0438 \u0432 \u043a\u0430\u0436\u0434\u043e\u0439 \u0441\u0442\u0440\u0430\u043d\u0435. \u0420\u0430\u043d\u044c\u0448\u0435 \u0434\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u043d\u0443\u0436\u043d\u043e \u0431\u044b\u043b\u043e \u043d\u0430\u043f\u0438\u0441\u0430\u0442\u044c \u0437\u0430\u043f\u0440\u043e\u0441 \u0432\u0438\u0434\u0430:  <\/p>\n
(SELECT sum(amount), c.country_id, NULL as city_id FROM payment AS p INNER JOIN city AS c ON p.city_id=c.id GROUP BY c.country_id ORDER BY c.country_id) UNION ALL (SELECT sum(amount), NULL, p.city_id FROM payment AS p GROUP BY p.city_id ORDER BY p.city_id) <\/code><\/pre>\n
  <\/p>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/b><\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
sum<\/th>\ncountry_id<\/th>\ncity_id<\/th>\n<\/tr>\n
19794121.93<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
30138426.57<\/td>\n2<\/td>\nNULL<\/td>\n<\/tr>\n
2420939.72<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
2611787.51<\/td>\nNULL<\/td>\n2<\/td>\n<\/tr>\n
2357570.54<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
2796471.48<\/td>\nNULL<\/td>\n4<\/td>\n<\/tr>\n
2327588.11<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
2563701.69<\/td>\nNULL<\/td>\n6<\/td>\n<\/tr>\n
2442654.38<\/td>\nNULL<\/td>\n7<\/td>\n<\/tr>\n
2273408.5<\/td>\nNULL<\/td>\n8<\/td>\n<\/tr>\n
2509228.24<\/td>\nNULL<\/td>\n9<\/td>\n<\/tr>\n
2716771.77<\/td>\nNULL<\/td>\n10<\/td>\n<\/tr>\n
2745394.99<\/td>\nNULL<\/td>\n11<\/td>\n<\/tr>\n
2554721.34<\/td>\nNULL<\/td>\n12<\/td>\n<\/tr>\n
2526112.36<\/td>\nNULL<\/td>\n13<\/td>\n<\/tr>\n
2818708.34<\/td>\nNULL<\/td>\n14<\/td>\n<\/tr>\n
2437768.84<\/td>\nNULL<\/td>\n15<\/td>\n<\/tr>\n
2246483.68<\/td>\nNULL<\/td>\n16<\/td>\n<\/tr>\n
2384795.14<\/td>\nNULL<\/td>\n17<\/td>\n<\/tr>\n
2437849.05<\/td>\nNULL<\/td>\n18<\/td>\n<\/tr>\n
2470876.07<\/td>\nNULL<\/td>\n19<\/td>\n<\/tr>\n
2289716.75<\/td>\nNULL<\/td>\n20<\/td>\n<\/tr>\n<\/table>\n
  <\/div>\n<\/div>\n
  \u0421 \u0432\u0435\u0440\u0441\u0438\u0438 9.5 \u043f\u043e\u0434\u043e\u0431\u043d\u044b\u0439 \u0437\u0430\u043f\u0440\u043e\u0441 \u043f\u0440\u043e\u0449\u0435 \u043d\u0430\u043f\u0438\u0441\u0430\u0442\u044c \u0442\u0430\u043a:  <\/p>\n
SELECT   sum(amount),   c.country_id,   p.city_id FROM payment AS p   INNER JOIN city AS c     ON p.city_id = c.id GROUP BY GROUPING SETS(c.country_id, p.city_id); <\/code><\/pre>\n
  <\/p>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/b><\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
sum<\/th>\ncountry_id<\/th>\ncity_id<\/th>\n<\/tr>\n
19794121.93<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
30138426.57<\/td>\n2<\/td>\nNULL<\/td>\n<\/tr>\n
2420939.72<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
2611787.51<\/td>\nNULL<\/td>\n2<\/td>\n<\/tr>\n
2357570.54<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
2796471.48<\/td>\nNULL<\/td>\n4<\/td>\n<\/tr>\n
2327588.11<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
2563701.69<\/td>\nNULL<\/td>\n6<\/td>\n<\/tr>\n
2442654.38<\/td>\nNULL<\/td>\n7<\/td>\n<\/tr>\n
2273408.5<\/td>\nNULL<\/td>\n8<\/td>\n<\/tr>\n
2509228.24<\/td>\nNULL<\/td>\n9<\/td>\n<\/tr>\n
2716771.77<\/td>\nNULL<\/td>\n10<\/td>\n<\/tr>\n
2745394.99<\/td>\nNULL<\/td>\n11<\/td>\n<\/tr>\n
2554721.34<\/td>\nNULL<\/td>\n12<\/td>\n<\/tr>\n
2526112.36<\/td>\nNULL<\/td>\n13<\/td>\n<\/tr>\n
2818708.34<\/td>\nNULL<\/td>\n14<\/td>\n<\/tr>\n
2437768.84<\/td>\nNULL<\/td>\n15<\/td>\n<\/tr>\n
2246483.68<\/td>\nNULL<\/td>\n16<\/td>\n<\/tr>\n
2384795.14<\/td>\nNULL<\/td>\n17<\/td>\n<\/tr>\n
2437849.05<\/td>\nNULL<\/td>\n18<\/td>\n<\/tr>\n
2470876.07<\/td>\nNULL<\/td>\n19<\/td>\n<\/tr>\n
2289716.75<\/td>\nNULL<\/td>\n20<\/td>\n<\/tr>\n<\/table>\n
  <\/div>\n<\/div>\n
  \u041a\u0430\u043a \u0432\u0438\u0434\u043d\u043e, GROUPING SETS<\/b> \u0432 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0434\u0430\u043d\u043d\u044b\u0435 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c: \u0432 \u043a\u0430\u0436\u0434\u043e\u0439 \u0441\u0442\u0440\u043e\u043a\u0435 \u043e\u0434\u043d\u043e\u0439 \u0438\u0437 \u043a\u043e\u043b\u043e\u043d\u043e\u043a \u0438\u0437 \u043f\u0435\u0440\u0435\u0447\u0438\u0441\u043b\u0435\u043d\u043d\u044b\u0445 \u0432 \u0441\u043a\u043e\u0431\u043a\u0430\u0445 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u0435\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435, \u0432 \u0442\u043e \u0432\u0440\u0435\u043c\u044f \u043a\u0430\u043a \u043e\u0441\u0442\u0430\u043b\u044c\u043d\u044b\u0435 \u043a\u043e\u043b\u043e\u043d\u043a\u0438 (\u0438\u0437 \u0441\u043f\u0438\u0441\u043a\u0430 \u0432 \u0441\u043a\u043e\u0431\u043a\u0430\u0445) \u0437\u0430\u043f\u043e\u043b\u043d\u0435\u043d\u044b NULL. \u041a\u043e\u043b\u043e\u043d\u043a\u0438 \u043d\u0435 \u043f\u0435\u0440\u0435\u0447\u0438\u0441\u043b\u0435\u043d\u043d\u044b\u0435 \u0432 GROUPING SETS<\/b>, \u0432\u044b\u0447\u0438\u0441\u043b\u044f\u044e\u0442\u0441\u044f \u043a\u0430\u043a \u043e\u0431\u044b\u0447\u043d\u043e.
  \u0427\u0442\u043e\u0431\u044b \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u0438 \u043f\u043e\u043b\u043d\u0443\u044e \u0441\u0443\u043c\u043c\u0443 (\u0431\u0435\u0437 \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0438) \u043c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043f\u0443\u0441\u0442\u0443\u044e \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0443 \u2014 ()<\/b>. \u041f\u0440\u0438 \u043f\u0443\u0441\u0442\u043e\u0439 \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0435 \u0432\u0441\u0435 \u043f\u043e\u043b\u044f, \u0443\u0447\u0430\u0441\u0442\u0432\u0443\u044e\u0449\u0438\u0435 \u0432 GROUPING SETS<\/b> \u0437\u0430\u043f\u043e\u043b\u043d\u0435\u043d\u044b NULL:  <\/p>\n
SELECT   sum(amount),   p.city_id,   c.country_id FROM payment AS p   INNER JOIN city AS c     ON p.city_id = c.id GROUP BY GROUPING SETS(p.city_id, C.country_id, ());<\/code><\/pre>\n
  <\/p>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/b><\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
sum<\/th>\ncountry_id<\/th>\ncity_id<\/th>\n<\/tr>\n
19794121.93<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
30138426.57<\/td>\n2<\/td>\nNULL<\/td>\n<\/tr>\n
49932548.5<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2420939.72<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
2611787.51<\/td>\nNULL<\/td>\n2<\/td>\n<\/tr>\n
2357570.54<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
2796471.48<\/td>\nNULL<\/td>\n4<\/td>\n<\/tr>\n
2327588.11<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
2563701.69<\/td>\nNULL<\/td>\n6<\/td>\n<\/tr>\n
2442654.38<\/td>\nNULL<\/td>\n7<\/td>\n<\/tr>\n
2273408.5<\/td>\nNULL<\/td>\n8<\/td>\n<\/tr>\n
2509228.24<\/td>\nNULL<\/td>\n9<\/td>\n<\/tr>\n
2716771.77<\/td>\nNULL<\/td>\n10<\/td>\n<\/tr>\n
2745394.99<\/td>\nNULL<\/td>\n11<\/td>\n<\/tr>\n
2554721.34<\/td>\nNULL<\/td>\n12<\/td>\n<\/tr>\n
2526112.36<\/td>\nNULL<\/td>\n13<\/td>\n<\/tr>\n
2818708.34<\/td>\nNULL<\/td>\n14<\/td>\n<\/tr>\n
2437768.84<\/td>\nNULL<\/td>\n15<\/td>\n<\/tr>\n
2246483.68<\/td>\nNULL<\/td>\n16<\/td>\n<\/tr>\n
2384795.14<\/td>\nNULL<\/td>\n17<\/td>\n<\/tr>\n
2437849.05<\/td>\nNULL<\/td>\n18<\/td>\n<\/tr>\n
2470876.07<\/td>\nNULL<\/td>\n19<\/td>\n<\/tr>\n
2289716.75<\/td>\nNULL<\/td>\n20<\/td>\n<\/tr>\n<\/table>\n
  <\/div>\n<\/div>\n
  \u041f\u043e\u043f\u0440\u043e\u0431\u0443\u0435\u043c \u0442\u0435\u043f\u0435\u0440\u044c \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u0441\u0443\u043c\u043c\u0443 \u043f\u043b\u0430\u0442\u0435\u0436\u0435\u0439 \u0432 \u0440\u0430\u0437\u0440\u0435\u0437\u0435 \u043f\u043e \u0433\u043e\u0440\u043e\u0434\u0430\u043c, \u0440\u0435\u0433\u0438\u043e\u043d\u0430\u043c \u0438 \u0441\u0442\u0440\u0430\u043d\u0430\u043c:  <\/p>\n
SELECT   sum(amount),   p.city_id,   c.state_id,   c.country_id FROM payment AS p   INNER JOIN city AS c     ON p.city_id = c.id GROUP BY GROUPING SETS(p.city_id, c.state_id, c.country_id); <\/code><\/pre>\n
  <\/p>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/b><\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
sum<\/th>\ncity_id<\/th>\nstate_id<\/th>\ncountry_id<\/th>\n<\/tr>\n
2420939.72<\/td>\n1<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2611787.51<\/td>\n2<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2357570.54<\/td>\n3<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2796471.48<\/td>\n4<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2327588.11<\/td>\n5<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2563701.69<\/td>\n6<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2442654.38<\/td>\n7<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2273408.5<\/td>\n8<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2509228.24<\/td>\n9<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2716771.77<\/td>\n10<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2745394.99<\/td>\n11<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2554721.34<\/td>\n12<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2526112.36<\/td>\n13<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2818708.34<\/td>\n14<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2437768.84<\/td>\n15<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2246483.68<\/td>\n16<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2384795.14<\/td>\n17<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2437849.05<\/td>\n18<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2470876.07<\/td>\n19<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2289716.75<\/td>\n20<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
19794121.93<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
30138426.57<\/td>\nNULL<\/td>\nNULL<\/td>\n2<\/td>\n<\/tr>\n
2611787.51<\/td>\nNULL<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
10045331.82<\/td>\nNULL<\/td>\n2<\/td>\nNULL<\/td>\n<\/tr>\n
2442654.38<\/td>\nNULL<\/td>\n3<\/td>\nNULL<\/td>\n<\/tr>\n
2273408.5<\/td>\nNULL<\/td>\n4<\/td>\nNULL<\/td>\n<\/tr>\n
8016888.1<\/td>\nNULL<\/td>\n5<\/td>\nNULL<\/td>\n<\/tr>\n
10029073.22<\/td>\nNULL<\/td>\n6<\/td>\nNULL<\/td>\n<\/tr>\n
4822644.19<\/td>\nNULL<\/td>\n7<\/td>\nNULL<\/td>\n<\/tr>\n
4760592.82<\/td>\nNULL<\/td>\n8<\/td>\nNULL<\/td>\n<\/tr>\n
4930167.96<\/td>\nNULL<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n<\/table>\n
  <\/div>\n<\/div>\n
  \u0421\u0442\u0440\u0430\u043d\u043d\u043e, \u043c\u044b \u043d\u0435 \u0434\u0435\u043b\u0430\u043b\u0438 \u043f\u0443\u0441\u0442\u0443\u044e \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0443, \u043d\u043e \u043f\u043e\u043b\u0443\u0447\u0438\u043b\u0438 \u0441\u0442\u0440\u043e\u043a\u0443 \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u0432\u0441\u0435 \u043f\u043e\u043b\u044f NULL. \u041d\u0430 \u0441\u0430\u043c\u043e\u043c \u0434\u0435\u043b\u0435, \u044d\u0442\u043e \u043f\u0440\u043e\u0438\u0437\u043e\u0448\u043b\u043e \u043f\u043e\u0442\u043e\u043c\u0443, \u0447\u0442\u043e \u0443 \u041c\u043e\u0441\u043a\u0432\u044b \u0438 \u041a\u0438\u0435\u0432\u0430 \u043f\u043e\u043b\u0435 state_id<\/b> \u043d\u0435 \u0437\u0430\u043f\u043e\u043b\u043d\u0435\u043d\u043e, \u043f\u043e\u044d\u0442\u043e\u043c\u0443 GROUPING SETS<\/b> \u0441\u043f\u0440\u0430\u0432\u0435\u0434\u043b\u0438\u0432\u043e \u0441\u0434\u0435\u043b\u0430\u043b \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0443 \u0438 \u043f\u043e state_id = NULL<\/i>. \u042d\u0442\u043e \u043b\u0435\u0433\u043a\u043e \u043f\u0440\u043e\u0432\u0435\u0440\u0438\u0442\u044c, \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u0432 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u0437\u0430\u043f\u0440\u043e\u0441:  <\/p>\n
SELECT sum(amount) FROM payment WHERE city_id IN (1, 9); <\/code><\/pre>\n
  <\/p>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/b><\/p>\n
\n\n\n\n
sum<\/th>\n<\/tr>\n
4930167.96<\/td>\n<\/tr>\n<\/table>\n
  <\/div>\n<\/div>\n
  \u0414\u0430, \u043d\u0430\u0448\u0435 \u043f\u0440\u0435\u0434\u043f\u043e\u043b\u043e\u0436\u0435\u043d\u0438\u0435 \u043e\u043a\u0430\u0437\u0430\u043b\u043e\u0441\u044c \u0432\u0435\u0440\u043d\u044b\u043c \u0438 \u0441\u0443\u043c\u043c\u044b \u0441\u043e\u0432\u043f\u0430\u043b\u0438.
  \u0425\u043e\u0440\u043e\u0448\u043e, \u0441 \u0442\u0435\u043c, \u043e\u0442\u043a\u0443\u0434\u0430 \u0431\u0435\u0440\u0435\u0442\u0441\u044f \u044d\u0442\u0430 \u0441\u0442\u0440\u0430\u043d\u043d\u0430\u044f \u0441\u0442\u0440\u043e\u043a\u0430 \u043c\u044b \u0440\u0430\u0437\u043e\u0431\u0440\u0430\u043b\u0438\u0441\u044c, \u043d\u043e \u043a\u0430\u043a \u043e\u0442\u043b\u0438\u0447\u0438\u0442\u044c \u0432 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435, \u0432 \u043a\u0430\u043a\u043e\u0439 \u0438\u0437 \u0441\u0442\u0440\u043e\u043a \u043f\u043e\u043b\u043d\u0430\u044f \u0441\u0443\u043c\u043c\u0430, \u0430 \u0432 \u043a\u0430\u043a\u043e\u0439 \u2014 \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0430 \u043f\u043e state_id = NULL<\/i>?  <\/p>\n
SELECT   sum(amount),   p.city_id,   c.state_id,   c.country_id FROM payment AS p   INNER JOIN city AS c     ON p.city_id = c.id GROUP BY GROUPING SETS(p.city_id, c.state_id, c.country_id, ()); <\/code><\/pre>\n
  <\/p>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/b><\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
sum<\/th>\ncity_id<\/th>\nstate_id<\/th>\ncountry_id<\/th>\n<\/tr>\n
2420939.72<\/td>\n1<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2611787.51<\/td>\n2<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2357570.54<\/td>\n3<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2796471.48<\/td>\n4<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2327588.11<\/td>\n5<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2563701.69<\/td>\n6<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2442654.38<\/td>\n7<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2273408.5<\/td>\n8<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2509228.24<\/td>\n9<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2716771.77<\/td>\n10<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2745394.99<\/td>\n11<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2554721.34<\/td>\n12<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2526112.36<\/td>\n13<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2818708.34<\/td>\n14<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2437768.84<\/td>\n15<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2246483.68<\/td>\n16<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2384795.14<\/td>\n17<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2437849.05<\/td>\n18<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2470876.07<\/td>\n19<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2289716.75<\/td>\n20<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
49932548.5<\/td>\nNULL<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
19794121.93<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
30138426.57<\/td>\nNULL<\/td>\nNULL<\/td>\n2<\/td>\n<\/tr>\n
2611787.51<\/td>\nNULL<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
10045331.82<\/td>\nNULL<\/td>\n2<\/td>\nNULL<\/td>\n<\/tr>\n
2442654.38<\/td>\nNULL<\/td>\n3<\/td>\nNULL<\/td>\n<\/tr>\n
2273408.5<\/td>\nNULL<\/td>\n4<\/td>\nNULL<\/td>\n<\/tr>\n
8016888.1<\/td>\nNULL<\/td>\n5<\/td>\nNULL<\/td>\n<\/tr>\n
10029073.22<\/td>\nNULL<\/td>\n6<\/td>\nNULL<\/td>\n<\/tr>\n
4822644.19<\/td>\nNULL<\/td>\n7<\/td>\nNULL<\/td>\n<\/tr>\n
4760592.82<\/td>\nNULL<\/td>\n8<\/td>\nNULL<\/td>\n<\/tr>\n
4930167.96<\/td>\nNULL<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n<\/table>\n
  <\/div>\n<\/div>\n
  \u0422\u0430\u043a \u0432\u0435\u0434\u044c \u0432 \u043f\u043e\u043b\u043d\u043e\u0439 \u0441\u0443\u043c\u043c\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u0431\u0443\u0434\u0435\u0442 \u0431\u043e\u043b\u044c\u0448\u0435, \u0441\u043a\u0430\u0436\u0435\u0442\u0435 \u0432\u044b, \u0438 \u0431\u0443\u0434\u0435\u0442\u0435 \u043f\u0440\u0430\u0432\u044b. \u041a\u043e\u043d\u0435\u0447\u043d\u043e, \u0432 \u0434\u0430\u043d\u043d\u043e\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435, \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u043d\u044f\u0442\u044c, \u0447\u0442\u043e \u0441\u0442\u0440\u043e\u043a\u0430 \u0441 \u0431\u00f3\u043b\u044c\u0448\u0435\u0439 \u0441\u0443\u043c\u043c\u043e\u0439 \u0438 \u0435\u0441\u0442\u044c \u043f\u043e\u043b\u043d\u0430\u044f \u0441\u0443\u043c\u043c\u0430. \u041e\u0434\u043d\u0430\u043a\u043e, \u0435\u0441\u043b\u0438 \u0431\u044b \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u0431\u044b\u043b\u0438 \u043d\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u043f\u043e\u043b\u043e\u0436\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f, \u043d\u043e \u0438 \u043e\u0442\u0440\u0438\u0446\u0430\u0442\u0435\u043b\u044c\u043d\u044b\u0435, \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u044c \u043f\u043e\u043b\u043d\u0443\u044e \u0441\u0443\u043c\u043c\u0443 \u0431\u044b\u043b\u043e \u0431\u044b \u0441\u043b\u043e\u0436\u043d\u0435\u0435. \u041d\u0443 \u0438\u043b\u0438 \u0435\u0441\u043b\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0434\u0440\u0443\u0433\u0443\u044e \u0430\u0433\u0440\u0435\u0433\u0430\u0442\u043d\u0443\u044e \u0444\u0443\u043d\u043a\u0446\u0438\u044e:  <\/p>\n
SELECT   avg(amount),   p.city_id,   c.state_id,   c.country_id FROM payment AS p   INNER JOIN city AS c     ON p.city_id = c.id GROUP BY GROUPING SETS(p.city_id, c.state_id, c.country_id, ());<\/code><\/pre>\n
  <\/p>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/b><\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
avg<\/th>\ncity_id<\/th>\nstate_id<\/th>\ncountry_id<\/th>\n<\/tr>\n
4841.87944<\/td>\n1<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5141.313996062992126<\/td>\n2<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4850.9681893004115226<\/td>\n3<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4958.2827659574468085<\/td>\n4<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4849.1418958333333333<\/td>\n5<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5096.8224453280318091<\/td>\n6<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5208.2182942430703625<\/td>\n7<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4985.5449561403508772<\/td>\n8<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5038.6109236947791165<\/td>\n9<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5135.6744234404536862<\/td>\n10<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5219.3821102661596958<\/td>\n11<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4903.4958541266794626<\/td>\n12<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5092.9684677419354839<\/td>\n13<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5006.5867495559502664<\/td>\n14<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4964.9059877800407332<\/td>\n15<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4992.1859555555555556<\/td>\n16<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4694.4786220472440945<\/td>\n17<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5047.3065217391304348<\/td>\n18<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4883.1542885375494071<\/td>\n19<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4945.392548596112311<\/td>\n20<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4993.25485<\/td>\nNULL<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4990.9535879979828543<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
4994.7674129930394432<\/td>\nNULL<\/td>\nNULL<\/td>\n2<\/td>\n<\/tr>\n
5141.313996062992126<\/td>\nNULL<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
4941.1371470732907034<\/td>\nNULL<\/td>\n2<\/td>\nNULL<\/td>\n<\/tr>\n
5208.2182942430703625<\/td>\nNULL<\/td>\n3<\/td>\nNULL<\/td>\n<\/tr>\n
4985.5449561403508772<\/td>\nNULL<\/td>\n4<\/td>\nNULL<\/td>\n<\/tr>\n
5086.8579314720812183<\/td>\nNULL<\/td>\n5<\/td>\nNULL<\/td>\n<\/tr>\n
5014.53661<\/td>\nNULL<\/td>\n6<\/td>\nNULL<\/td>\n<\/tr>\n
4866.4421695257315843<\/td>\nNULL<\/td>\n7<\/td>\nNULL<\/td>\n<\/tr>\n
4912.8924871001031992<\/td>\nNULL<\/td>\n8<\/td>\nNULL<\/td>\n<\/tr>\n
4940.0480561122244489<\/td>\nNULL<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n<\/table>\n
  <\/div>\n<\/div>\n
  \u041a\u0430\u043a\u0430\u044f \u0441\u0442\u0440\u043e\u043a\u0430 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u0435\u0442 \u0441\u0440\u0435\u0434\u043d\u0435\u0439 \u0441\u0443\u043c\u043c\u0435 \u043f\u043b\u0430\u0442\u0435\u0436\u0430 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435, \u0430 \u043a\u0430\u043a\u0430\u044f \u2014 \u0441\u0440\u0435\u0434\u043d\u0435\u0439 \u0441\u0443\u043c\u043c\u0435 \u043f\u043e \u041a\u0438\u0435\u0432\u0443 \u0438 \u041c\u043e\u0441\u043a\u0432\u0435?
  \u041a \u0441\u0447\u0430\u0441\u0442\u044c\u044e, \u0440\u0435\u0448\u0435\u043d\u0438\u0435 \u0435\u0441\u0442\u044c: \u043d\u043e\u0432\u0430\u044f \u0444\u0443\u043d\u043a\u0446\u0438\u044f grouping()<\/b>, \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043d\u0435\u0451 \u043c\u044b \u043c\u043e\u0436\u0435\u043c \u0443\u0437\u043d\u0430\u0442\u044c, \u0443\u0447\u0430\u0441\u0442\u0432\u0443\u0435\u0442 \u043b\u0438 \u0432 \u0434\u0430\u043d\u043d\u043e\u0439 \u0441\u0442\u0440\u043e\u043a\u0435 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u043d\u0430\u044f \u043a\u043e\u043b\u043e\u043d\u043a\u0430 \u0432 \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0435. \u0415\u0441\u043b\u0438 grouping(column_name)<\/b> \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 0, \u0442\u043e column_name \u0443\u0447\u0430\u0441\u0442\u0432\u0443\u0435\u0442 \u0432 \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0435, \u0435\u0441\u043b\u0438 1 \u2014 \u043d\u0435 \u0443\u0447\u0430\u0441\u0442\u0432\u0443\u0435\u0442:  <\/p>\n
SELECT   avg(amount),   p.city_id,   c.state_id,   c.country_id,   grouping(c.state_id) FROM payment AS p   INNER JOIN city AS c     ON p.city_id = c.id GROUP BY GROUPING SETS(p.city_id, c.state_id, c.country_id, ());<\/code><\/pre>\n
  <\/p>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/b><\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
avg<\/th>\ncity_id<\/th>\nstate_id<\/th>\ncountry_id<\/th>\ngrouping<\/th>\n<\/tr>\n
4841.87944<\/td>\n1<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
5141.313996062992126<\/td>\n2<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
4850.9681893004115226<\/td>\n3<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
4958.2827659574468085<\/td>\n4<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
4849.1418958333333333<\/td>\n5<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
5096.8224453280318091<\/td>\n6<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
5208.2182942430703625<\/td>\n7<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
4985.5449561403508772<\/td>\n8<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
5038.6109236947791165<\/td>\n9<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
5135.6744234404536862<\/td>\n10<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
5219.3821102661596958<\/td>\n11<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
4903.4958541266794626<\/td>\n12<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
5092.9684677419354839<\/td>\n13<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
5006.5867495559502664<\/td>\n14<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
4964.9059877800407332<\/td>\n15<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
4992.1859555555555556<\/td>\n16<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
4694.4786220472440945<\/td>\n17<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
5047.3065217391304348<\/td>\n18<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
4883.1542885375494071<\/td>\n19<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
4945.392548596112311<\/td>\n20<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
4993.25485<\/td>\nNULL<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
4990.9535879979828543<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n1<\/td>\n<\/tr>\n
4994.7674129930394432<\/td>\nNULL<\/td>\nNULL<\/td>\n2<\/td>\n1<\/td>\n<\/tr>\n
5141.313996062992126<\/td>\nNULL<\/td>\n1<\/td>\nNULL<\/td>\n0<\/td>\n<\/tr>\n
4941.1371470732907034<\/td>\nNULL<\/td>\n2<\/td>\nNULL<\/td>\n0<\/td>\n<\/tr>\n
5208.2182942430703625<\/td>\nNULL<\/td>\n3<\/td>\nNULL<\/td>\n0<\/td>\n<\/tr>\n
4985.5449561403508772<\/td>\nNULL<\/td>\n4<\/td>\nNULL<\/td>\n0<\/td>\n<\/tr>\n
5086.8579314720812183<\/td>\nNULL<\/td>\n5<\/td>\nNULL<\/td>\n0<\/td>\n<\/tr>\n
5014.53661<\/td>\nNULL<\/td>\n6<\/td>\nNULL<\/td>\n0<\/td>\n<\/tr>\n
4866.4421695257315843<\/td>\nNULL<\/td>\n7<\/td>\nNULL<\/td>\n0<\/td>\n<\/tr>\n
4912.8924871001031992<\/td>\nNULL<\/td>\n8<\/td>\nNULL<\/td>\n0<\/td>\n<\/tr>\n
4940.0480561122244489<\/td>\nNULL<\/td>\nNULL<\/td>\nNULL<\/td>\n0<\/td>\n<\/tr>\n<\/table>\n
  <\/div>\n<\/div>\n
  \u041d\u0430 \u0441\u0430\u043c\u043e\u043c \u0434\u0435\u043b\u0435, grouping<\/b> \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0431\u0438\u0442\u043e\u0432\u0443\u044e \u043c\u0430\u0441\u043a\u0443 \u0434\u043b\u044f \u043a\u043e\u043b\u043e\u043d\u043e\u043a \u043f\u0435\u0440\u0435\u0447\u0438\u0441\u043b\u0435\u043d\u043d\u044b\u0445 \u0432 \u043d\u0435\u0439:  <\/p>\n
SELECT   avg(amount),   p.city_id,   c.state_id,   c.country_id,   grouping(p.city_id, c.state_id, c.country_id) FROM payment AS p   INNER JOIN city AS c     ON p.city_id = c.id GROUP BY GROUPING SETS(p.city_id, c.state_id, c.country_id, ());<\/code><\/pre>\n
  <\/p>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/b><\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
avg<\/th>\ncity_id<\/th>\nstate_id<\/th>\ncountry_id<\/th>\ngrouping<\/th>\n<\/tr>\n
4841.87944<\/td>\n1<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
5141.313996062992126<\/td>\n2<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
4850.9681893004115226<\/td>\n3<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
4958.2827659574468085<\/td>\n4<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
4849.1418958333333333<\/td>\n5<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
5096.8224453280318091<\/td>\n6<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
5208.2182942430703625<\/td>\n7<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
4985.5449561403508772<\/td>\n8<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
5038.6109236947791165<\/td>\n9<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
5135.6744234404536862<\/td>\n10<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
5219.3821102661596958<\/td>\n11<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
4903.4958541266794626<\/td>\n12<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
5092.9684677419354839<\/td>\n13<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
5006.5867495559502664<\/td>\n14<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
4964.9059877800407332<\/td>\n15<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
4992.1859555555555556<\/td>\n16<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
4694.4786220472440945<\/td>\n17<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
5047.3065217391304348<\/td>\n18<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
4883.1542885375494071<\/td>\n19<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
4945.392548596112311<\/td>\n20<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
4993.25485<\/td>\nNULL<\/td>\nNULL<\/td>\nNULL<\/td>\n7<\/td>\n<\/tr>\n
4990.9535879979828543<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n6<\/td>\n<\/tr>\n
4994.7674129930394432<\/td>\nNULL<\/td>\nNULL<\/td>\n2<\/td>\n6<\/td>\n<\/tr>\n
5141.313996062992126<\/td>\nNULL<\/td>\n1<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
4941.1371470732907034<\/td>\nNULL<\/td>\n2<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
5208.2182942430703625<\/td>\nNULL<\/td>\n3<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
4985.5449561403508772<\/td>\nNULL<\/td>\n4<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
5086.8579314720812183<\/td>\nNULL<\/td>\n5<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
5014.53661<\/td>\nNULL<\/td>\n6<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
4866.4421695257315843<\/td>\nNULL<\/td>\n7<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
4912.8924871001031992<\/td>\nNULL<\/td>\n8<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
4940.0480561122244489<\/td>\nNULL<\/td>\nNULL<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n<\/table>\n
  <\/div>\n<\/div>\n
  \u0422\u0430\u043a \u043d\u0435 \u043e\u0447\u0435\u043d\u044c \u043f\u043e\u043d\u044f\u0442\u043d\u043e, \u043f\u0440\u0438\u0432\u0435\u0434\u0435\u043c \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u043a \u0442\u0438\u043f\u0443 bit(3)<\/b>:  <\/p>\n
SELECT   avg(amount),   p.city_id,   c.state_id,   c.country_id,   grouping(p.city_id, c.state_id, c.country_id) :: BIT(3) FROM payment AS p   INNER JOIN city AS c     ON p.city_id = c.id GROUP BY GROUPING SETS(p.city_id, c.state_id, c.country_id, ());<\/code><\/pre>\n
  <\/p>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/b><\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
avg<\/th>\ncity_id<\/th>\nstate_id<\/th>\ncountry_id<\/th>\ngrouping<\/th>\n<\/tr>\n
4841.87944<\/td>\n1<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
5141.313996062992126<\/td>\n2<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
4850.9681893004115226<\/td>\n3<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
4958.2827659574468085<\/td>\n4<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
4849.1418958333333333<\/td>\n5<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
5096.8224453280318091<\/td>\n6<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
5208.2182942430703625<\/td>\n7<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
4985.5449561403508772<\/td>\n8<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
5038.6109236947791165<\/td>\n9<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
5135.6744234404536862<\/td>\n10<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
5219.3821102661596958<\/td>\n11<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
4903.4958541266794626<\/td>\n12<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
5092.9684677419354839<\/td>\n13<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
5006.5867495559502664<\/td>\n14<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
4964.9059877800407332<\/td>\n15<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
4992.1859555555555556<\/td>\n16<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
4694.4786220472440945<\/td>\n17<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
5047.3065217391304348<\/td>\n18<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
4883.1542885375494071<\/td>\n19<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
4945.392548596112311<\/td>\n20<\/td>\nNULL<\/td>\nNULL<\/td>\n011<\/td>\n<\/tr>\n
4993.25485<\/td>\nNULL<\/td>\nNULL<\/td>\nNULL<\/td>\n111<\/td>\n<\/tr>\n
4990.9535879979828543<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n110<\/td>\n<\/tr>\n
4994.7674129930394432<\/td>\nNULL<\/td>\nNULL<\/td>\n2<\/td>\n110<\/td>\n<\/tr>\n
5141.313996062992126<\/td>\nNULL<\/td>\n1<\/td>\nNULL<\/td>\n101<\/td>\n<\/tr>\n
4941.1371470732907034<\/td>\nNULL<\/td>\n2<\/td>\nNULL<\/td>\n101<\/td>\n<\/tr>\n
5208.2182942430703625<\/td>\nNULL<\/td>\n3<\/td>\nNULL<\/td>\n101<\/td>\n<\/tr>\n
4985.5449561403508772<\/td>\nNULL<\/td>\n4<\/td>\nNULL<\/td>\n101<\/td>\n<\/tr>\n
5086.8579314720812183<\/td>\nNULL<\/td>\n5<\/td>\nNULL<\/td>\n101<\/td>\n<\/tr>\n
5014.53661<\/td>\nNULL<\/td>\n6<\/td>\nNULL<\/td>\n101<\/td>\n<\/tr>\n
4866.4421695257315843<\/td>\nNULL<\/td>\n7<\/td>\nNULL<\/td>\n101<\/td>\n<\/tr>\n
4912.8924871001031992<\/td>\nNULL<\/td>\n8<\/td>\nNULL<\/td>\n101<\/td>\n<\/tr>\n
4940.0480561122244489<\/td>\nNULL<\/td>\nNULL<\/td>\nNULL<\/td>\n101<\/td>\n<\/tr>\n<\/table>\n
  <\/div>\n<\/div>\n
  \u0422\u0430\u043a\u0436\u0435 \u043c\u043e\u0436\u043d\u043e \u0432 \u043e\u0434\u043d\u043e\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0432\u043c\u0435\u0441\u0442\u0435 \u043e\u0431\u044b\u0447\u043d\u0443\u044e \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0443 \u0438 \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0443 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e GROUPING SETS<\/b>:  <\/p>\n
SELECT   avg(amount),   c.country_id,   p.payment_type_id,   p.city_id,   c.state_id FROM payment AS p   INNER JOIN city AS c     ON p.city_id = c.id GROUP BY c.country_id, p.payment_type_id, GROUPING SETS(p.city_id, c.state_id, ());<\/code><\/pre>\n
  <\/p>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/b><\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
avg<\/th>\ncountry_id<\/th>\npayment_type_id<\/th>\ncity_id<\/th>\nstate_id<\/th>\n<\/tr>\n
5024.1955882352941176<\/td>\n1<\/td>\n1<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
4871.1540119760479042<\/td>\n1<\/td>\n1<\/td>\n2<\/td>\nNULL<\/td>\n<\/tr>\n
4891.0804861111111111<\/td>\n1<\/td>\n1<\/td>\n3<\/td>\nNULL<\/td>\n<\/tr>\n
5130.3479896907216495<\/td>\n1<\/td>\n1<\/td>\n4<\/td>\nNULL<\/td>\n<\/tr>\n
4739.4527586206896552<\/td>\n1<\/td>\n1<\/td>\n5<\/td>\nNULL<\/td>\n<\/tr>\n
4803.7104<\/td>\n1<\/td>\n1<\/td>\n6<\/td>\nNULL<\/td>\n<\/tr>\n
5028.8194375<\/td>\n1<\/td>\n1<\/td>\n7<\/td>\nNULL<\/td>\n<\/tr>\n
4903.6742<\/td>\n1<\/td>\n1<\/td>\n8<\/td>\nNULL<\/td>\n<\/tr>\n
4931.2117088122605364<\/td>\n1<\/td>\n1<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4407.8555056179775281<\/td>\n1<\/td>\n2<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
5068.5559638554216867<\/td>\n1<\/td>\n2<\/td>\n2<\/td>\nNULL<\/td>\n<\/tr>\n
4812.6204093567251462<\/td>\n1<\/td>\n2<\/td>\n3<\/td>\nNULL<\/td>\n<\/tr>\n
4564.1131034482758621<\/td>\n1<\/td>\n2<\/td>\n4<\/td>\nNULL<\/td>\n<\/tr>\n
4963.2932530120481928<\/td>\n1<\/td>\n2<\/td>\n5<\/td>\nNULL<\/td>\n<\/tr>\n
5153.3501219512195122<\/td>\n1<\/td>\n2<\/td>\n6<\/td>\nNULL<\/td>\n<\/tr>\n
5446.8668965517241379<\/td>\n1<\/td>\n2<\/td>\n7<\/td>\nNULL<\/td>\n<\/tr>\n
5057.8818012422360248<\/td>\n1<\/td>\n2<\/td>\n8<\/td>\nNULL<\/td>\n<\/tr>\n
4917.934422641509434<\/td>\n1<\/td>\n2<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5146.2380921052631579<\/td>\n1<\/td>\n3<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
5468.14<\/td>\n1<\/td>\n3<\/td>\n2<\/td>\nNULL<\/td>\n<\/tr>\n
4855.5371929824561404<\/td>\n1<\/td>\n3<\/td>\n3<\/td>\nNULL<\/td>\n<\/tr>\n
5137.8994387755102041<\/td>\n1<\/td>\n3<\/td>\n4<\/td>\nNULL<\/td>\n<\/tr>\n
4831.1288757396449704<\/td>\n1<\/td>\n3<\/td>\n5<\/td>\nNULL<\/td>\n<\/tr>\n
5353.0667682926829268<\/td>\n1<\/td>\n3<\/td>\n6<\/td>\nNULL<\/td>\n<\/tr>\n
5172.241280487804878<\/td>\n1<\/td>\n3<\/td>\n7<\/td>\nNULL<\/td>\n<\/tr>\n
4989.92<\/td>\n1<\/td>\n3<\/td>\n8<\/td>\nNULL<\/td>\n<\/tr>\n
5121.7272005988023952<\/td>\n1<\/td>\n3<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5224.1245625<\/td>\n2<\/td>\n1<\/td>\n9<\/td>\nNULL<\/td>\n<\/tr>\n
5137.9207142857142857<\/td>\n2<\/td>\n1<\/td>\n10<\/td>\nNULL<\/td>\n<\/tr>\n
5173.0209625668449198<\/td>\n2<\/td>\n1<\/td>\n11<\/td>\nNULL<\/td>\n<\/tr>\n
4735.6070652173913043<\/td>\n2<\/td>\n1<\/td>\n12<\/td>\nNULL<\/td>\n<\/tr>\n
5248.0194285714285714<\/td>\n2<\/td>\n1<\/td>\n13<\/td>\nNULL<\/td>\n<\/tr>\n
4929.1857978723404255<\/td>\n2<\/td>\n1<\/td>\n14<\/td>\nNULL<\/td>\n<\/tr>\n
5086.2014102564102564<\/td>\n2<\/td>\n1<\/td>\n15<\/td>\nNULL<\/td>\n<\/tr>\n
4716.9701273885350318<\/td>\n2<\/td>\n1<\/td>\n16<\/td>\nNULL<\/td>\n<\/tr>\n
4616.2608383233532934<\/td>\n2<\/td>\n1<\/td>\n17<\/td>\nNULL<\/td>\n<\/tr>\n
4756.9175641025641026<\/td>\n2<\/td>\n1<\/td>\n18<\/td>\nNULL<\/td>\n<\/tr>\n
4698.7787272727272727<\/td>\n2<\/td>\n1<\/td>\n19<\/td>\nNULL<\/td>\n<\/tr>\n
5033.8821276595744681<\/td>\n2<\/td>\n1<\/td>\n20<\/td>\nNULL<\/td>\n<\/tr>\n
4947.559810379241517<\/td>\n2<\/td>\n1<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5195.4805945945945946<\/td>\n2<\/td>\n2<\/td>\n9<\/td>\nNULL<\/td>\n<\/tr>\n
5213.8818617021276596<\/td>\n2<\/td>\n2<\/td>\n10<\/td>\nNULL<\/td>\n<\/tr>\n
5332.2921935483870968<\/td>\n2<\/td>\n2<\/td>\n11<\/td>\nNULL<\/td>\n<\/tr>\n
4946.331030303030303<\/td>\n2<\/td>\n2<\/td>\n12<\/td>\nNULL<\/td>\n<\/tr>\n
5020.5288888888888889<\/td>\n2<\/td>\n2<\/td>\n13<\/td>\nNULL<\/td>\n<\/tr>\n
5019.8181914893617021<\/td>\n2<\/td>\n2<\/td>\n14<\/td>\nNULL<\/td>\n<\/tr>\n
4875.5393452380952381<\/td>\n2<\/td>\n2<\/td>\n15<\/td>\nNULL<\/td>\n<\/tr>\n
5169.0016551724137931<\/td>\n2<\/td>\n2<\/td>\n16<\/td>\nNULL<\/td>\n<\/tr>\n
4605.4601807228915663<\/td>\n2<\/td>\n2<\/td>\n17<\/td>\nNULL<\/td>\n<\/tr>\n
4930.9780838323353293<\/td>\n2<\/td>\n2<\/td>\n18<\/td>\nNULL<\/td>\n<\/tr>\n
4985.6017441860465116<\/td>\n2<\/td>\n2<\/td>\n19<\/td>\nNULL<\/td>\n<\/tr>\n
5137.4943046357615894<\/td>\n2<\/td>\n2<\/td>\n20<\/td>\nNULL<\/td>\n<\/tr>\n
5035.3225511732401398<\/td>\n2<\/td>\n2<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4654.930718954248366<\/td>\n2<\/td>\n3<\/td>\n9<\/td>\nNULL<\/td>\n<\/tr>\n
5048.5046242774566474<\/td>\n2<\/td>\n3<\/td>\n10<\/td>\nNULL<\/td>\n<\/tr>\n
5171.3846739130434783<\/td>\n2<\/td>\n3<\/td>\n11<\/td>\nNULL<\/td>\n<\/tr>\n
5042.0059302325581395<\/td>\n2<\/td>\n3<\/td>\n12<\/td>\nNULL<\/td>\n<\/tr>\n
4997.4288095238095238<\/td>\n2<\/td>\n3<\/td>\n13<\/td>\nNULL<\/td>\n<\/tr>\n
5071.0994117647058824<\/td>\n2<\/td>\n3<\/td>\n14<\/td>\nNULL<\/td>\n<\/tr>\n
4941.5018562874251497<\/td>\n2<\/td>\n3<\/td>\n15<\/td>\nNULL<\/td>\n<\/tr>\n
5110.9062837837837838<\/td>\n2<\/td>\n3<\/td>\n16<\/td>\nNULL<\/td>\n<\/tr>\n
4853.5610857142857143<\/td>\n2<\/td>\n3<\/td>\n17<\/td>\nNULL<\/td>\n<\/tr>\n
5451.8535625<\/td>\n2<\/td>\n3<\/td>\n18<\/td>\nNULL<\/td>\n<\/tr>\n
4958.8998816568047337<\/td>\n2<\/td>\n3<\/td>\n19<\/td>\nNULL<\/td>\n<\/tr>\n
4702.7937426900584795<\/td>\n2<\/td>\n3<\/td>\n20<\/td>\nNULL<\/td>\n<\/tr>\n
5001.3644005920078934<\/td>\n2<\/td>\n3<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4871.1540119760479042<\/td>\n1<\/td>\n1<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
4904.9742705167173252<\/td>\n1<\/td>\n1<\/td>\nNULL<\/td>\n2<\/td>\n<\/tr>\n
5028.8194375<\/td>\n1<\/td>\n1<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
4903.6742<\/td>\n1<\/td>\n1<\/td>\nNULL<\/td>\n4<\/td>\n<\/tr>\n
5024.1955882352941176<\/td>\n1<\/td>\n1<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5068.5559638554216867<\/td>\n1<\/td>\n2<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
4868.3998074074074074<\/td>\n1<\/td>\n2<\/td>\nNULL<\/td>\n2<\/td>\n<\/tr>\n
5446.8668965517241379<\/td>\n1<\/td>\n2<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
5057.8818012422360248<\/td>\n1<\/td>\n2<\/td>\nNULL<\/td>\n4<\/td>\n<\/tr>\n
4407.8555056179775281<\/td>\n1<\/td>\n2<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5468.14<\/td>\n1<\/td>\n3<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
5045.2698285714285714<\/td>\n1<\/td>\n3<\/td>\nNULL<\/td>\n2<\/td>\n<\/tr>\n
5172.241280487804878<\/td>\n1<\/td>\n3<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
4989.92<\/td>\n1<\/td>\n3<\/td>\nNULL<\/td>\n4<\/td>\n<\/tr>\n
5146.2380921052631579<\/td>\n1<\/td>\n3<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5012.7593692022263451<\/td>\n2<\/td>\n1<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
4998.6716863905325444<\/td>\n2<\/td>\n1<\/td>\nNULL<\/td>\n6<\/td>\n<\/tr>\n
4684.1941176470588235<\/td>\n2<\/td>\n1<\/td>\nNULL<\/td>\n7<\/td>\n<\/tr>\n
4853.1891176470588235<\/td>\n2<\/td>\n1<\/td>\nNULL<\/td>\n8<\/td>\n<\/tr>\n
5224.1245625<\/td>\n2<\/td>\n1<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5163.1096456692913386<\/td>\n2<\/td>\n2<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
5015.9978440366972477<\/td>\n2<\/td>\n2<\/td>\nNULL<\/td>\n6<\/td>\n<\/tr>\n
4768.7078978978978979<\/td>\n2<\/td>\n2<\/td>\nNULL<\/td>\n7<\/td>\n<\/tr>\n
5056.6103405572755418<\/td>\n2<\/td>\n2<\/td>\nNULL<\/td>\n8<\/td>\n<\/tr>\n
5195.4805945945945946<\/td>\n2<\/td>\n2<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5089.1325141776937618<\/td>\n2<\/td>\n3<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
5029.1172686567164179<\/td>\n2<\/td>\n3<\/td>\nNULL<\/td>\n6<\/td>\n<\/tr>\n
5139.3127164179104478<\/td>\n2<\/td>\n3<\/td>\nNULL<\/td>\n7<\/td>\n<\/tr>\n
4830.0935588235294118<\/td>\n2<\/td>\n3<\/td>\nNULL<\/td>\n8<\/td>\n<\/tr>\n
4654.930718954248366<\/td>\n2<\/td>\n3<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n<\/table>\n
  <\/div>\n<\/div>\n
  \u041c\u043e\u0436\u043d\u043e \u043e\u0431\u044a\u0435\u0434\u0438\u043d\u044f\u0442\u044c \u043a\u043e\u043b\u043e\u043d\u043a\u0438 \u0432\u043d\u0443\u0442\u0440\u0438 GROUPING SETS<\/b> \u0432 \u0433\u0440\u0443\u043f\u043f\u044b  <\/p>\n
SELECT   avg(amount),   c.country_id,   p.payment_type_id,   p.city_id,   c.state_id FROM payment AS p   INNER JOIN city AS c     ON p.city_id = c.id GROUP BY GROUPING SETS((p.payment_type_id, c.country_id), ( c.state_id, p.city_id));<\/code><\/pre>\n
  <\/p>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/b><\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
avg<\/th>\ncountry_id<\/th>\npayment_type_id<\/th>\ncity_id<\/th>\nstate_id<\/th>\n<\/tr>\n
4931.2117088122605364<\/td>\n1<\/td>\n1<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4947.559810379241517<\/td>\n2<\/td>\n1<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
4917.934422641509434<\/td>\n1<\/td>\n2<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5035.3225511732401398<\/td>\n2<\/td>\n2<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5121.7272005988023952<\/td>\n1<\/td>\n3<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5001.3644005920078934<\/td>\n2<\/td>\n3<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
5141.313996062992126<\/td>\nNULL<\/td>\nNULL<\/td>\n2<\/td>\n1<\/td>\n<\/tr>\n
4850.9681893004115226<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n2<\/td>\n<\/tr>\n
4958.2827659574468085<\/td>\nNULL<\/td>\nNULL<\/td>\n4<\/td>\n2<\/td>\n<\/tr>\n
4849.1418958333333333<\/td>\nNULL<\/td>\nNULL<\/td>\n5<\/td>\n2<\/td>\n<\/tr>\n
5096.8224453280318091<\/td>\nNULL<\/td>\nNULL<\/td>\n6<\/td>\n2<\/td>\n<\/tr>\n
5208.2182942430703625<\/td>\nNULL<\/td>\nNULL<\/td>\n7<\/td>\n3<\/td>\n<\/tr>\n
4985.5449561403508772<\/td>\nNULL<\/td>\nNULL<\/td>\n8<\/td>\n4<\/td>\n<\/tr>\n
5135.6744234404536862<\/td>\nNULL<\/td>\nNULL<\/td>\n10<\/td>\n5<\/td>\n<\/tr>\n
5219.3821102661596958<\/td>\nNULL<\/td>\nNULL<\/td>\n11<\/td>\n5<\/td>\n<\/tr>\n
4903.4958541266794626<\/td>\nNULL<\/td>\nNULL<\/td>\n12<\/td>\n5<\/td>\n<\/tr>\n
5092.9684677419354839<\/td>\nNULL<\/td>\nNULL<\/td>\n13<\/td>\n6<\/td>\n<\/tr>\n
5006.5867495559502664<\/td>\nNULL<\/td>\nNULL<\/td>\n14<\/td>\n6<\/td>\n<\/tr>\n
4964.9059877800407332<\/td>\nNULL<\/td>\nNULL<\/td>\n15<\/td>\n6<\/td>\n<\/tr>\n
4992.1859555555555556<\/td>\nNULL<\/td>\nNULL<\/td>\n16<\/td>\n6<\/td>\n<\/tr>\n
4694.4786220472440945<\/td>\nNULL<\/td>\nNULL<\/td>\n17<\/td>\n7<\/td>\n<\/tr>\n
5047.3065217391304348<\/td>\nNULL<\/td>\nNULL<\/td>\n18<\/td>\n7<\/td>\n<\/tr>\n
4883.1542885375494071<\/td>\nNULL<\/td>\nNULL<\/td>\n19<\/td>\n8<\/td>\n<\/tr>\n
4945.392548596112311<\/td>\nNULL<\/td>\nNULL<\/td>\n20<\/td>\n8<\/td>\n<\/tr>\n
4841.87944<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
5038.6109236947791165<\/td>\nNULL<\/td>\nNULL<\/td>\n9<\/td>\nNULL<\/td>\n<\/tr>\n<\/table>\n
  <\/div>\n<\/div>\n
  \u0422\u0435\u043f\u0435\u0440\u044c \u043f\u0435\u0440\u0435\u0439\u0434\u0435\u043c \u043a CUBE<\/b>. CUBE<\/b> \u2014 \u044d\u0442\u043e \u0447\u0442\u043e-\u0442\u043e \u0432\u0440\u043e\u0434\u0435 \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u0433\u043e GROUPING SETS<\/b>.
  CUBE<\/b> \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0434\u0430\u043d\u043d\u044b\u0435 \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u044b\u0445 \u0441\u043e\u0447\u0435\u0442\u0430\u043d\u0438\u0439 \u043a\u043e\u043b\u043e\u043d\u043e\u043a, \u043f\u0435\u0440\u0435\u0447\u0438\u0441\u043b\u0435\u043d\u043d\u044b\u0445 \u0432\u043d\u0443\u0442\u0440\u0438. \u0422\u043e \u0435\u0441\u0442\u044c \u0434\u043b\u044f \u0441\u043b\u0443\u0447\u0430\u044f CUBE(c1, c2, c3<\/i>)<\/b>(\u0433\u0434\u0435 \u04411, c2, c3 \u2014 \u0438\u043c\u0435\u043d\u0430 \u043a\u043e\u043b\u043e\u043d\u043e\u043a) \u0431\u0443\u0434\u0443\u0442 \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0435\u043d\u044b \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0441\u043e\u0447\u0435\u0442\u0430\u043d\u0438\u044f:
  (\u04411, null, null)
  (null, c2, null)
  (null, null, c3)
  (c1, c2, null)
  (c1, null, c3)
  (null, c2, c3)
  (c1, c2, c3)
  (null, null, null)<\/i>
  \u041f\u0440\u0438\u043c\u0435\u0440:  <\/p>\n
SELECT   sum(amount),   p.payment_type_id,   c.country_id,   p.city_id FROM payment AS p   INNER JOIN city AS c     ON p.city_id = c.id GROUP BY CUBE(p.payment_type_id, c.country_id, p.city_id);<\/code><\/pre>\n
  <\/p>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/b><\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
sum<\/th>\npayment_type_id<\/th>\ncountry_id<\/th>\ncity_id<\/th>\n<\/tr>\n
854113.25<\/td>\n1<\/td>\n1<\/td>\n1<\/td>\n<\/tr>\n
813482.72<\/td>\n1<\/td>\n1<\/td>\n2<\/td>\n<\/tr>\n
704315.59<\/td>\n1<\/td>\n1<\/td>\n3<\/td>\n<\/tr>\n
995287.51<\/td>\n1<\/td>\n1<\/td>\n4<\/td>\n<\/tr>\n
687220.65<\/td>\n1<\/td>\n1<\/td>\n5<\/td>\n<\/tr>\n
840649.32<\/td>\n1<\/td>\n1<\/td>\n6<\/td>\n<\/tr>\n
804611.11<\/td>\n1<\/td>\n1<\/td>\n7<\/td>\n<\/tr>\n
735551.13<\/td>\n1<\/td>\n1<\/td>\n8<\/td>\n<\/tr>\n
6435231.28<\/td>\n1<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
835859.93<\/td>\n1<\/td>\n2<\/td>\n9<\/td>\n<\/tr>\n
863170.68<\/td>\n1<\/td>\n2<\/td>\n10<\/td>\n<\/tr>\n
967354.92<\/td>\n1<\/td>\n2<\/td>\n11<\/td>\n<\/tr>\n
871351.7<\/td>\n1<\/td>\n2<\/td>\n12<\/td>\n<\/tr>\n
918403.4<\/td>\n1<\/td>\n2<\/td>\n13<\/td>\n<\/tr>\n
926686.93<\/td>\n1<\/td>\n2<\/td>\n14<\/td>\n<\/tr>\n
793447.42<\/td>\n1<\/td>\n2<\/td>\n15<\/td>\n<\/tr>\n
740564.31<\/td>\n1<\/td>\n2<\/td>\n16<\/td>\n<\/tr>\n
770915.56<\/td>\n1<\/td>\n2<\/td>\n17<\/td>\n<\/tr>\n
742079.14<\/td>\n1<\/td>\n2<\/td>\n18<\/td>\n<\/tr>\n
775298.49<\/td>\n1<\/td>\n2<\/td>\n19<\/td>\n<\/tr>\n
709777.38<\/td>\n1<\/td>\n2<\/td>\n20<\/td>\n<\/tr>\n
9914909.86<\/td>\n1<\/td>\n2<\/td>\nNULL<\/td>\n<\/tr>\n
16350141.14<\/td>\n1<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
784598.28<\/td>\n2<\/td>\n1<\/td>\n1<\/td>\n<\/tr>\n
841380.29<\/td>\n2<\/td>\n1<\/td>\n2<\/td>\n<\/tr>\n
822958.09<\/td>\n2<\/td>\n1<\/td>\n3<\/td>\n<\/tr>\n
794155.68<\/td>\n2<\/td>\n1<\/td>\n4<\/td>\n<\/tr>\n
823906.68<\/td>\n2<\/td>\n1<\/td>\n5<\/td>\n<\/tr>\n
845149.42<\/td>\n2<\/td>\n1<\/td>\n6<\/td>\n<\/tr>\n
789795.7<\/td>\n2<\/td>\n1<\/td>\n7<\/td>\n<\/tr>\n
814318.97<\/td>\n2<\/td>\n1<\/td>\n8<\/td>\n<\/tr>\n
6516263.11<\/td>\n2<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
961163.91<\/td>\n2<\/td>\n2<\/td>\n9<\/td>\n<\/tr>\n
980209.79<\/td>\n2<\/td>\n2<\/td>\n10<\/td>\n<\/tr>\n
826505.29<\/td>\n2<\/td>\n2<\/td>\n11<\/td>\n<\/tr>\n
816144.62<\/td>\n2<\/td>\n2<\/td>\n12<\/td>\n<\/tr>\n
768140.92<\/td>\n2<\/td>\n2<\/td>\n13<\/td>\n<\/tr>\n
943725.82<\/td>\n2<\/td>\n2<\/td>\n14<\/td>\n<\/tr>\n
819090.61<\/td>\n2<\/td>\n2<\/td>\n15<\/td>\n<\/tr>\n
749505.24<\/td>\n2<\/td>\n2<\/td>\n16<\/td>\n<\/tr>\n
764506.39<\/td>\n2<\/td>\n2<\/td>\n17<\/td>\n<\/tr>\n
823473.34<\/td>\n2<\/td>\n2<\/td>\n18<\/td>\n<\/tr>\n
857523.5<\/td>\n2<\/td>\n2<\/td>\n19<\/td>\n<\/tr>\n
775761.64<\/td>\n2<\/td>\n2<\/td>\n20<\/td>\n<\/tr>\n
10085751.07<\/td>\n2<\/td>\n2<\/td>\nNULL<\/td>\n<\/tr>\n
16602014.18<\/td>\n2<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
782228.19<\/td>\n3<\/td>\n1<\/td>\n1<\/td>\n<\/tr>\n
956924.5<\/td>\n3<\/td>\n1<\/td>\n2<\/td>\n<\/tr>\n
830296.86<\/td>\n3<\/td>\n1<\/td>\n3<\/td>\n<\/tr>\n
1007028.29<\/td>\n3<\/td>\n1<\/td>\n4<\/td>\n<\/tr>\n
816460.78<\/td>\n3<\/td>\n1<\/td>\n5<\/td>\n<\/tr>\n
877902.95<\/td>\n3<\/td>\n1<\/td>\n6<\/td>\n<\/tr>\n
848247.57<\/td>\n3<\/td>\n1<\/td>\n7<\/td>\n<\/tr>\n
723538.4<\/td>\n3<\/td>\n1<\/td>\n8<\/td>\n<\/tr>\n
6842627.54<\/td>\n3<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
712204.4<\/td>\n3<\/td>\n2<\/td>\n9<\/td>\n<\/tr>\n
873391.3<\/td>\n3<\/td>\n2<\/td>\n10<\/td>\n<\/tr>\n
951534.78<\/td>\n3<\/td>\n2<\/td>\n11<\/td>\n<\/tr>\n
867225.02<\/td>\n3<\/td>\n2<\/td>\n12<\/td>\n<\/tr>\n
839568.04<\/td>\n3<\/td>\n2<\/td>\n13<\/td>\n<\/tr>\n
948295.59<\/td>\n3<\/td>\n2<\/td>\n14<\/td>\n<\/tr>\n
825230.81<\/td>\n3<\/td>\n2<\/td>\n15<\/td>\n<\/tr>\n
756414.13<\/td>\n3<\/td>\n2<\/td>\n16<\/td>\n<\/tr>\n
849373.19<\/td>\n3<\/td>\n2<\/td>\n17<\/td>\n<\/tr>\n
872296.57<\/td>\n3<\/td>\n2<\/td>\n18<\/td>\n<\/tr>\n
838054.08<\/td>\n3<\/td>\n2<\/td>\n19<\/td>\n<\/tr>\n
804177.73<\/td>\n3<\/td>\n2<\/td>\n20<\/td>\n<\/tr>\n
10137765.64<\/td>\n3<\/td>\n2<\/td>\nNULL<\/td>\n<\/tr>\n
16980393.18<\/td>\n3<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
49932548.5<\/td>\nNULL<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
854113.25<\/td>\n1<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
784598.28<\/td>\n2<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
782228.19<\/td>\n3<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
2420939.72<\/td>\nNULL<\/td>\nNULL<\/td>\n1<\/td>\n<\/tr>\n
813482.72<\/td>\n1<\/td>\nNULL<\/td>\n2<\/td>\n<\/tr>\n
841380.29<\/td>\n2<\/td>\nNULL<\/td>\n2<\/td>\n<\/tr>\n
956924.5<\/td>\n3<\/td>\nNULL<\/td>\n2<\/td>\n<\/tr>\n
2611787.51<\/td>\nNULL<\/td>\nNULL<\/td>\n2<\/td>\n<\/tr>\n
704315.59<\/td>\n1<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
822958.09<\/td>\n2<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
830296.86<\/td>\n3<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
2357570.54<\/td>\nNULL<\/td>\nNULL<\/td>\n3<\/td>\n<\/tr>\n
995287.51<\/td>\n1<\/td>\nNULL<\/td>\n4<\/td>\n<\/tr>\n
794155.68<\/td>\n2<\/td>\nNULL<\/td>\n4<\/td>\n<\/tr>\n
1007028.29<\/td>\n3<\/td>\nNULL<\/td>\n4<\/td>\n<\/tr>\n
2796471.48<\/td>\nNULL<\/td>\nNULL<\/td>\n4<\/td>\n<\/tr>\n
687220.65<\/td>\n1<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
823906.68<\/td>\n2<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
816460.78<\/td>\n3<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
2327588.11<\/td>\nNULL<\/td>\nNULL<\/td>\n5<\/td>\n<\/tr>\n
840649.32<\/td>\n1<\/td>\nNULL<\/td>\n6<\/td>\n<\/tr>\n
845149.42<\/td>\n2<\/td>\nNULL<\/td>\n6<\/td>\n<\/tr>\n
877902.95<\/td>\n3<\/td>\nNULL<\/td>\n6<\/td>\n<\/tr>\n
2563701.69<\/td>\nNULL<\/td>\nNULL<\/td>\n6<\/td>\n<\/tr>\n
804611.11<\/td>\n1<\/td>\nNULL<\/td>\n7<\/td>\n<\/tr>\n
789795.7<\/td>\n2<\/td>\nNULL<\/td>\n7<\/td>\n<\/tr>\n
848247.57<\/td>\n3<\/td>\nNULL<\/td>\n7<\/td>\n<\/tr>\n
2442654.38<\/td>\nNULL<\/td>\nNULL<\/td>\n7<\/td>\n<\/tr>\n
735551.13<\/td>\n1<\/td>\nNULL<\/td>\n8<\/td>\n<\/tr>\n
814318.97<\/td>\n2<\/td>\nNULL<\/td>\n8<\/td>\n<\/tr>\n
723538.4<\/td>\n3<\/td>\nNULL<\/td>\n8<\/td>\n<\/tr>\n
2273408.5<\/td>\nNULL<\/td>\nNULL<\/td>\n8<\/td>\n<\/tr>\n
835859.93<\/td>\n1<\/td>\nNULL<\/td>\n9<\/td>\n<\/tr>\n
961163.91<\/td>\n2<\/td>\nNULL<\/td>\n9<\/td>\n<\/tr>\n
712204.4<\/td>\n3<\/td>\nNULL<\/td>\n9<\/td>\n<\/tr>\n
2509228.24<\/td>\nNULL<\/td>\nNULL<\/td>\n9<\/td>\n<\/tr>\n
863170.68<\/td>\n1<\/td>\nNULL<\/td>\n10<\/td>\n<\/tr>\n
980209.79<\/td>\n2<\/td>\nNULL<\/td>\n10<\/td>\n<\/tr>\n
873391.3<\/td>\n3<\/td>\nNULL<\/td>\n10<\/td>\n<\/tr>\n
2716771.77<\/td>\nNULL<\/td>\nNULL<\/td>\n10<\/td>\n<\/tr>\n
967354.92<\/td>\n1<\/td>\nNULL<\/td>\n11<\/td>\n<\/tr>\n
826505.29<\/td>\n2<\/td>\nNULL<\/td>\n11<\/td>\n<\/tr>\n
951534.78<\/td>\n3<\/td>\nNULL<\/td>\n11<\/td>\n<\/tr>\n
2745394.99<\/td>\nNULL<\/td>\nNULL<\/td>\n11<\/td>\n<\/tr>\n
871351.7<\/td>\n1<\/td>\nNULL<\/td>\n12<\/td>\n<\/tr>\n
816144.62<\/td>\n2<\/td>\nNULL<\/td>\n12<\/td>\n<\/tr>\n
867225.02<\/td>\n3<\/td>\nNULL<\/td>\n12<\/td>\n<\/tr>\n
2554721.34<\/td>\nNULL<\/td>\nNULL<\/td>\n12<\/td>\n<\/tr>\n
918403.4<\/td>\n1<\/td>\nNULL<\/td>\n13<\/td>\n<\/tr>\n
768140.92<\/td>\n2<\/td>\nNULL<\/td>\n13<\/td>\n<\/tr>\n
839568.04<\/td>\n3<\/td>\nNULL<\/td>\n13<\/td>\n<\/tr>\n
2526112.36<\/td>\nNULL<\/td>\nNULL<\/td>\n13<\/td>\n<\/tr>\n
926686.93<\/td>\n1<\/td>\nNULL<\/td>\n14<\/td>\n<\/tr>\n
943725.82<\/td>\n2<\/td>\nNULL<\/td>\n14<\/td>\n<\/tr>\n
948295.59<\/td>\n3<\/td>\nNULL<\/td>\n14<\/td>\n<\/tr>\n
2818708.34<\/td>\nNULL<\/td>\nNULL<\/td>\n14<\/td>\n<\/tr>\n
793447.42<\/td>\n1<\/td>\nNULL<\/td>\n15<\/td>\n<\/tr>\n
819090.61<\/td>\n2<\/td>\nNULL<\/td>\n15<\/td>\n<\/tr>\n
825230.81<\/td>\n3<\/td>\nNULL<\/td>\n15<\/td>\n<\/tr>\n
2437768.84<\/td>\nNULL<\/td>\nNULL<\/td>\n15<\/td>\n<\/tr>\n
740564.31<\/td>\n1<\/td>\nNULL<\/td>\n16<\/td>\n<\/tr>\n
749505.24<\/td>\n2<\/td>\nNULL<\/td>\n16<\/td>\n<\/tr>\n
756414.13<\/td>\n3<\/td>\nNULL<\/td>\n16<\/td>\n<\/tr>\n
2246483.68<\/td>\nNULL<\/td>\nNULL<\/td>\n16<\/td>\n<\/tr>\n
770915.56<\/td>\n1<\/td>\nNULL<\/td>\n17<\/td>\n<\/tr>\n
764506.39<\/td>\n2<\/td>\nNULL<\/td>\n17<\/td>\n<\/tr>\n
849373.19<\/td>\n3<\/td>\nNULL<\/td>\n17<\/td>\n<\/tr>\n
2384795.14<\/td>\nNULL<\/td>\nNULL<\/td>\n17<\/td>\n<\/tr>\n
742079.14<\/td>\n1<\/td>\nNULL<\/td>\n18<\/td>\n<\/tr>\n
823473.34<\/td>\n2<\/td>\nNULL<\/td>\n18<\/td>\n<\/tr>\n
872296.57<\/td>\n3<\/td>\nNULL<\/td>\n18<\/td>\n<\/tr>\n
2437849.05<\/td>\nNULL<\/td>\nNULL<\/td>\n18<\/td>\n<\/tr>\n
775298.49<\/td>\n1<\/td>\nNULL<\/td>\n19<\/td>\n<\/tr>\n
857523.5<\/td>\n2<\/td>\nNULL<\/td>\n19<\/td>\n<\/tr>\n
838054.08<\/td>\n3<\/td>\nNULL<\/td>\n19<\/td>\n<\/tr>\n
2470876.07<\/td>\nNULL<\/td>\nNULL<\/td>\n19<\/td>\n<\/tr>\n
709777.38<\/td>\n1<\/td>\nNULL<\/td>\n20<\/td>\n<\/tr>\n
775761.64<\/td>\n2<\/td>\nNULL<\/td>\n20<\/td>\n<\/tr>\n
804177.73<\/td>\n3<\/td>\nNULL<\/td>\n20<\/td>\n<\/tr>\n
2289716.75<\/td>\nNULL<\/td>\nNULL<\/td>\n20<\/td>\n<\/tr>\n
2420939.72<\/td>\nNULL<\/td>\n1<\/td>\n1<\/td>\n<\/tr>\n
2611787.51<\/td>\nNULL<\/td>\n1<\/td>\n2<\/td>\n<\/tr>\n
2357570.54<\/td>\nNULL<\/td>\n1<\/td>\n3<\/td>\n<\/tr>\n
2796471.48<\/td>\nNULL<\/td>\n1<\/td>\n4<\/td>\n<\/tr>\n
2327588.11<\/td>\nNULL<\/td>\n1<\/td>\n5<\/td>\n<\/tr>\n
2563701.69<\/td>\nNULL<\/td>\n1<\/td>\n6<\/td>\n<\/tr>\n
2442654.38<\/td>\nNULL<\/td>\n1<\/td>\n7<\/td>\n<\/tr>\n
2273408.5<\/td>\nNULL<\/td>\n1<\/td>\n8<\/td>\n<\/tr>\n
19794121.93<\/td>\nNULL<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
2509228.24<\/td>\nNULL<\/td>\n2<\/td>\n9<\/td>\n<\/tr>\n
2716771.77<\/td>\nNULL<\/td>\n2<\/td>\n10<\/td>\n<\/tr>\n
2745394.99<\/td>\nNULL<\/td>\n2<\/td>\n11<\/td>\n<\/tr>\n
2554721.34<\/td>\nNULL<\/td>\n2<\/td>\n12<\/td>\n<\/tr>\n
2526112.36<\/td>\nNULL<\/td>\n2<\/td>\n13<\/td>\n<\/tr>\n
2818708.34<\/td>\nNULL<\/td>\n2<\/td>\n14<\/td>\n<\/tr>\n
2437768.84<\/td>\nNULL<\/td>\n2<\/td>\n15<\/td>\n<\/tr>\n
2246483.68<\/td>\nNULL<\/td>\n2<\/td>\n16<\/td>\n<\/tr>\n
2384795.14<\/td>\nNULL<\/td>\n2<\/td>\n17<\/td>\n<\/tr>\n
2437849.05<\/td>\nNULL<\/td>\n2<\/td>\n18<\/td>\n<\/tr>\n
2470876.07<\/td>\nNULL<\/td>\n2<\/td>\n19<\/td>\n<\/tr>\n
2289716.75<\/td>\nNULL<\/td>\n2<\/td>\n20<\/td>\n<\/tr>\n
30138426.57<\/td>\nNULL<\/td>\n2<\/td>\nNULL<\/td>\n<\/tr>\n<\/table>\n
  <\/div>\n<\/div>\n
  \u041a\u0430\u043a \u0438 \u0432 GROUPING SETS<\/b> \u043c\u043e\u0436\u043d\u043e \u0434\u0435\u043b\u0430\u0442\u044c \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0443 \u0432\u043d\u0443\u0442\u0440\u0438:  <\/p>\n
SELECT   sum(amount),   p.payment_type_id,   c.country_id,   p.city_id FROM payment AS p   INNER JOIN city AS c     ON p.city_id = c.id GROUP BY CUBE(p.payment_type_id, (c.country_id, p.city_id));<\/code><\/pre>\n
  <\/p>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/b><\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
sum<\/th>\npayment_type_id<\/th>\ncountry_id<\/th>\ncity_id<\/th>\n<\/tr>\n
854113.25<\/td>\n1<\/td>\n1<\/td>\n1<\/td>\n<\/tr>\n
813482.72<\/td>\n1<\/td>\n1<\/td>\n2<\/td>\n<\/tr>\n
704315.59<\/td>\n1<\/td>\n1<\/td>\n3<\/td>\n<\/tr>\n
995287.51<\/td>\n1<\/td>\n1<\/td>\n4<\/td>\n<\/tr>\n
687220.65<\/td>\n1<\/td>\n1<\/td>\n5<\/td>\n<\/tr>\n
840649.32<\/td>\n1<\/td>\n1<\/td>\n6<\/td>\n<\/tr>\n
804611.11<\/td>\n1<\/td>\n1<\/td>\n7<\/td>\n<\/tr>\n
735551.13<\/td>\n1<\/td>\n1<\/td>\n8<\/td>\n<\/tr>\n
835859.93<\/td>\n1<\/td>\n2<\/td>\n9<\/td>\n<\/tr>\n
863170.68<\/td>\n1<\/td>\n2<\/td>\n10<\/td>\n<\/tr>\n
967354.92<\/td>\n1<\/td>\n2<\/td>\n11<\/td>\n<\/tr>\n
871351.7<\/td>\n1<\/td>\n2<\/td>\n12<\/td>\n<\/tr>\n
918403.4<\/td>\n1<\/td>\n2<\/td>\n13<\/td>\n<\/tr>\n
926686.93<\/td>\n1<\/td>\n2<\/td>\n14<\/td>\n<\/tr>\n
793447.42<\/td>\n1<\/td>\n2<\/td>\n15<\/td>\n<\/tr>\n
740564.31<\/td>\n1<\/td>\n2<\/td>\n16<\/td>\n<\/tr>\n
770915.56<\/td>\n1<\/td>\n2<\/td>\n17<\/td>\n<\/tr>\n
742079.14<\/td>\n1<\/td>\n2<\/td>\n18<\/td>\n<\/tr>\n
775298.49<\/td>\n1<\/td>\n2<\/td>\n19<\/td>\n<\/tr>\n
709777.38<\/td>\n1<\/td>\n2<\/td>\n20<\/td>\n<\/tr>\n
16350141.14<\/td>\n1<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
784598.28<\/td>\n2<\/td>\n1<\/td>\n1<\/td>\n<\/tr>\n
841380.29<\/td>\n2<\/td>\n1<\/td>\n2<\/td>\n<\/tr>\n
822958.09<\/td>\n2<\/td>\n1<\/td>\n3<\/td>\n<\/tr>\n
794155.68<\/td>\n2<\/td>\n1<\/td>\n4<\/td>\n<\/tr>\n
823906.68<\/td>\n2<\/td>\n1<\/td>\n5<\/td>\n<\/tr>\n
845149.42<\/td>\n2<\/td>\n1<\/td>\n6<\/td>\n<\/tr>\n
789795.7<\/td>\n2<\/td>\n1<\/td>\n7<\/td>\n<\/tr>\n
814318.97<\/td>\n2<\/td>\n1<\/td>\n8<\/td>\n<\/tr>\n
961163.91<\/td>\n2<\/td>\n2<\/td>\n9<\/td>\n<\/tr>\n
980209.79<\/td>\n2<\/td>\n2<\/td>\n10<\/td>\n<\/tr>\n
826505.29<\/td>\n2<\/td>\n2<\/td>\n11<\/td>\n<\/tr>\n
816144.62<\/td>\n2<\/td>\n2<\/td>\n12<\/td>\n<\/tr>\n
768140.92<\/td>\n2<\/td>\n2<\/td>\n13<\/td>\n<\/tr>\n
943725.82<\/td>\n2<\/td>\n2<\/td>\n14<\/td>\n<\/tr>\n
819090.61<\/td>\n2<\/td>\n2<\/td>\n15<\/td>\n<\/tr>\n
749505.24<\/td>\n2<\/td>\n2<\/td>\n16<\/td>\n<\/tr>\n
764506.39<\/td>\n2<\/td>\n2<\/td>\n17<\/td>\n<\/tr>\n
823473.34<\/td>\n2<\/td>\n2<\/td>\n18<\/td>\n<\/tr>\n
857523.5<\/td>\n2<\/td>\n2<\/td>\n19<\/td>\n<\/tr>\n
775761.64<\/td>\n2<\/td>\n2<\/td>\n20<\/td>\n<\/tr>\n
16602014.18<\/td>\n2<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
782228.19<\/td>\n3<\/td>\n1<\/td>\n1<\/td>\n<\/tr>\n
956924.5<\/td>\n3<\/td>\n1<\/td>\n2<\/td>\n<\/tr>\n
830296.86<\/td>\n3<\/td>\n1<\/td>\n3<\/td>\n<\/tr>\n
1007028.29<\/td>\n3<\/td>\n1<\/td>\n4<\/td>\n<\/tr>\n
816460.78<\/td>\n3<\/td>\n1<\/td>\n5<\/td>\n<\/tr>\n
877902.95<\/td>\n3<\/td>\n1<\/td>\n6<\/td>\n<\/tr>\n
848247.57<\/td>\n3<\/td>\n1<\/td>\n7<\/td>\n<\/tr>\n
723538.4<\/td>\n3<\/td>\n1<\/td>\n8<\/td>\n<\/tr>\n
712204.4<\/td>\n3<\/td>\n2<\/td>\n9<\/td>\n<\/tr>\n
873391.3<\/td>\n3<\/td>\n2<\/td>\n10<\/td>\n<\/tr>\n
951534.78<\/td>\n3<\/td>\n2<\/td>\n11<\/td>\n<\/tr>\n
867225.02<\/td>\n3<\/td>\n2<\/td>\n12<\/td>\n<\/tr>\n
839568.04<\/td>\n3<\/td>\n2<\/td>\n13<\/td>\n<\/tr>\n
948295.59<\/td>\n3<\/td>\n2<\/td>\n14<\/td>\n<\/tr>\n
825230.81<\/td>\n3<\/td>\n2<\/td>\n15<\/td>\n<\/tr>\n
756414.13<\/td>\n3<\/td>\n2<\/td>\n16<\/td>\n<\/tr>\n
849373.19<\/td>\n3<\/td>\n2<\/td>\n17<\/td>\n<\/tr>\n
872296.57<\/td>\n3<\/td>\n2<\/td>\n18<\/td>\n<\/tr>\n
838054.08<\/td>\n3<\/td>\n2<\/td>\n19<\/td>\n<\/tr>\n
804177.73<\/td>\n3<\/td>\n2<\/td>\n20<\/td>\n<\/tr>\n
16980393.18<\/td>\n3<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
49932548.5<\/td>\nNULL<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
2420939.72<\/td>\nNULL<\/td>\n1<\/td>\n1<\/td>\n<\/tr>\n
2611787.51<\/td>\nNULL<\/td>\n1<\/td>\n2<\/td>\n<\/tr>\n
2357570.54<\/td>\nNULL<\/td>\n1<\/td>\n3<\/td>\n<\/tr>\n
2796471.48<\/td>\nNULL<\/td>\n1<\/td>\n4<\/td>\n<\/tr>\n
2327588.11<\/td>\nNULL<\/td>\n1<\/td>\n5<\/td>\n<\/tr>\n
2563701.69<\/td>\nNULL<\/td>\n1<\/td>\n6<\/td>\n<\/tr>\n
2442654.38<\/td>\nNULL<\/td>\n1<\/td>\n7<\/td>\n<\/tr>\n
2273408.5<\/td>\nNULL<\/td>\n1<\/td>\n8<\/td>\n<\/tr>\n
2509228.24<\/td>\nNULL<\/td>\n2<\/td>\n9<\/td>\n<\/tr>\n
2716771.77<\/td>\nNULL<\/td>\n2<\/td>\n10<\/td>\n<\/tr>\n
2745394.99<\/td>\nNULL<\/td>\n2<\/td>\n11<\/td>\n<\/tr>\n
2554721.34<\/td>\nNULL<\/td>\n2<\/td>\n12<\/td>\n<\/tr>\n
2526112.36<\/td>\nNULL<\/td>\n2<\/td>\n13<\/td>\n<\/tr>\n
2818708.34<\/td>\nNULL<\/td>\n2<\/td>\n14<\/td>\n<\/tr>\n
2437768.84<\/td>\nNULL<\/td>\n2<\/td>\n15<\/td>\n<\/tr>\n
2246483.68<\/td>\nNULL<\/td>\n2<\/td>\n16<\/td>\n<\/tr>\n
2384795.14<\/td>\nNULL<\/td>\n2<\/td>\n17<\/td>\n<\/tr>\n
2437849.05<\/td>\nNULL<\/td>\n2<\/td>\n18<\/td>\n<\/tr>\n
2470876.07<\/td>\nNULL<\/td>\n2<\/td>\n19<\/td>\n<\/tr>\n
2289716.75<\/td>\nNULL<\/td>\n2<\/td>\n20<\/td>\n<\/tr>\n<\/table>\n
  <\/div>\n<\/div>\n
  ROLLUP<\/b> \u0442\u0430\u043a \u0436\u0435, \u043a\u0430\u043a \u0438 CUBE<\/b> \u2014 \u0447\u0442\u043e-\u0442\u043e \u0432\u0440\u043e\u0434\u0435 \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u0433\u043e GROUPING SETS<\/b>, \u0441 \u0442\u0435\u043c \u043e\u0442\u043b\u0438\u0447\u0438\u0435\u043c, \u0447\u0442\u043e ROLLUP<\/b> \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 \u0441\u043e\u0447\u0435\u0442\u0430\u043d\u0438\u044f, \u0443\u0431\u0438\u0440\u0430\u044f \u043a\u043e\u043b\u043e\u043d\u043a\u0438 \u043f\u043e \u043e\u0434\u043d\u043e\u0439 \u0441 \u043a\u043e\u043d\u0446\u0430. \u0422\u0430\u043a\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c, ROLLUP(c1, c2, c3, c4<\/i>)<\/b> \u0432\u0435\u0440\u043d\u0435\u0442 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0441\u043e\u0447\u0435\u0442\u0430\u043d\u0438\u044f:
  (c1, c2, c3, c4)
  (c1, c2, c3, null)
  (c1, c2, null, null)
  (c1, null, null, null)
  (null, null, null, null)<\/i>
  \u041f\u0440\u0438\u043c\u0435\u0440:  <\/p>\n
SELECT   sum(amount),   p.payment_type_id,   c.country_id,   p.city_id FROM payment AS p   INNER JOIN city AS c     ON p.city_id = c.id GROUP BY ROLLUP(p.payment_type_id, c.country_id, p.city_id);<\/code><\/pre>\n
  <\/p>\n
\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/b><\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
sum<\/th>\npayment_type_id<\/th>\ncountry_id<\/th>\ncity_id<\/th>\n<\/tr>\n
854113.25<\/td>\n1<\/td>\n1<\/td>\n1<\/td>\n<\/tr>\n
813482.72<\/td>\n1<\/td>\n1<\/td>\n2<\/td>\n<\/tr>\n
704315.59<\/td>\n1<\/td>\n1<\/td>\n3<\/td>\n<\/tr>\n
995287.51<\/td>\n1<\/td>\n1<\/td>\n4<\/td>\n<\/tr>\n
687220.65<\/td>\n1<\/td>\n1<\/td>\n5<\/td>\n<\/tr>\n
840649.32<\/td>\n1<\/td>\n1<\/td>\n6<\/td>\n<\/tr>\n
804611.11<\/td>\n1<\/td>\n1<\/td>\n7<\/td>\n<\/tr>\n
735551.13<\/td>\n1<\/td>\n1<\/td>\n8<\/td>\n<\/tr>\n
6435231.28<\/td>\n1<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
835859.93<\/td>\n1<\/td>\n2<\/td>\n9<\/td>\n<\/tr>\n
863170.68<\/td>\n1<\/td>\n2<\/td>\n10<\/td>\n<\/tr>\n
967354.92<\/td>\n1<\/td>\n2<\/td>\n11<\/td>\n<\/tr>\n
871351.7<\/td>\n1<\/td>\n2<\/td>\n12<\/td>\n<\/tr>\n
918403.4<\/td>\n1<\/td>\n2<\/td>\n13<\/td>\n<\/tr>\n
926686.93<\/td>\n1<\/td>\n2<\/td>\n14<\/td>\n<\/tr>\n
793447.42<\/td>\n1<\/td>\n2<\/td>\n15<\/td>\n<\/tr>\n
740564.31<\/td>\n1<\/td>\n2<\/td>\n16<\/td>\n<\/tr>\n
770915.56<\/td>\n1<\/td>\n2<\/td>\n17<\/td>\n<\/tr>\n
742079.14<\/td>\n1<\/td>\n2<\/td>\n18<\/td>\n<\/tr>\n
775298.49<\/td>\n1<\/td>\n2<\/td>\n19<\/td>\n<\/tr>\n
709777.38<\/td>\n1<\/td>\n2<\/td>\n20<\/td>\n<\/tr>\n
9914909.86<\/td>\n1<\/td>\n2<\/td>\nNULL<\/td>\n<\/tr>\n
16350141.14<\/td>\n1<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
784598.28<\/td>\n2<\/td>\n1<\/td>\n1<\/td>\n<\/tr>\n
841380.29<\/td>\n2<\/td>\n1<\/td>\n2<\/td>\n<\/tr>\n
822958.09<\/td>\n2<\/td>\n1<\/td>\n3<\/td>\n<\/tr>\n
794155.68<\/td>\n2<\/td>\n1<\/td>\n4<\/td>\n<\/tr>\n
823906.68<\/td>\n2<\/td>\n1<\/td>\n5<\/td>\n<\/tr>\n
845149.42<\/td>\n2<\/td>\n1<\/td>\n6<\/td>\n<\/tr>\n
789795.7<\/td>\n2<\/td>\n1<\/td>\n7<\/td>\n<\/tr>\n
814318.97<\/td>\n2<\/td>\n1<\/td>\n8<\/td>\n<\/tr>\n
6516263.11<\/td>\n2<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
961163.91<\/td>\n2<\/td>\n2<\/td>\n9<\/td>\n<\/tr>\n
980209.79<\/td>\n2<\/td>\n2<\/td>\n10<\/td>\n<\/tr>\n
826505.29<\/td>\n2<\/td>\n2<\/td>\n11<\/td>\n<\/tr>\n
816144.62<\/td>\n2<\/td>\n2<\/td>\n12<\/td>\n<\/tr>\n
768140.92<\/td>\n2<\/td>\n2<\/td>\n13<\/td>\n<\/tr>\n
943725.82<\/td>\n2<\/td>\n2<\/td>\n14<\/td>\n<\/tr>\n
819090.61<\/td>\n2<\/td>\n2<\/td>\n15<\/td>\n<\/tr>\n
749505.24<\/td>\n2<\/td>\n2<\/td>\n16<\/td>\n<\/tr>\n
764506.39<\/td>\n2<\/td>\n2<\/td>\n17<\/td>\n<\/tr>\n
823473.34<\/td>\n2<\/td>\n2<\/td>\n18<\/td>\n<\/tr>\n
857523.5<\/td>\n2<\/td>\n2<\/td>\n19<\/td>\n<\/tr>\n
775761.64<\/td>\n2<\/td>\n2<\/td>\n20<\/td>\n<\/tr>\n
10085751.07<\/td>\n2<\/td>\n2<\/td>\nNULL<\/td>\n<\/tr>\n
16602014.18<\/td>\n2<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
782228.19<\/td>\n3<\/td>\n1<\/td>\n1<\/td>\n<\/tr>\n
956924.5<\/td>\n3<\/td>\n1<\/td>\n2<\/td>\n<\/tr>\n
830296.86<\/td>\n3<\/td>\n1<\/td>\n3<\/td>\n<\/tr>\n
1007028.29<\/td>\n3<\/td>\n1<\/td>\n4<\/td>\n<\/tr>\n
816460.78<\/td>\n3<\/td>\n1<\/td>\n5<\/td>\n<\/tr>\n
877902.95<\/td>\n3<\/td>\n1<\/td>\n6<\/td>\n<\/tr>\n
848247.57<\/td>\n3<\/td>\n1<\/td>\n7<\/td>\n<\/tr>\n
723538.4<\/td>\n3<\/td>\n1<\/td>\n8<\/td>\n<\/tr>\n
6842627.54<\/td>\n3<\/td>\n1<\/td>\nNULL<\/td>\n<\/tr>\n
712204.4<\/td>\n3<\/td>\n2<\/td>\n9<\/td>\n<\/tr>\n
873391.3<\/td>\n3<\/td>\n2<\/td>\n10<\/td>\n<\/tr>\n
951534.78<\/td>\n3<\/td>\n2<\/td>\n11<\/td>\n<\/tr>\n
867225.02<\/td>\n3<\/td>\n2<\/td>\n12<\/td>\n<\/tr>\n
839568.04<\/td>\n3<\/td>\n2<\/td>\n13<\/td>\n<\/tr>\n
948295.59<\/td>\n3<\/td>\n2<\/td>\n14<\/td>\n<\/tr>\n
825230.81<\/td>\n3<\/td>\n2<\/td>\n15<\/td>\n<\/tr>\n
756414.13<\/td>\n3<\/td>\n2<\/td>\n16<\/td>\n<\/tr>\n
849373.19<\/td>\n3<\/td>\n2<\/td>\n17<\/td>\n<\/tr>\n
872296.57<\/td>\n3<\/td>\n2<\/td>\n18<\/td>\n<\/tr>\n
838054.08<\/td>\n3<\/td>\n2<\/td>\n19<\/td>\n<\/tr>\n
804177.73<\/td>\n3<\/td>\n2<\/td>\n20<\/td>\n<\/tr>\n
10137765.64<\/td>\n3<\/td>\n2<\/td>\nNULL<\/td>\n<\/tr>\n
16980393.18<\/td>\n3<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n
49932548.5<\/td>\nNULL<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n<\/table>\n
  <\/div>\n<\/div>\n
  \u0412 \u0437\u0430\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435 \u0445\u043e\u0447\u0443 \u0441\u043a\u0430\u0437\u0430\u0442\u044c, \u0447\u0442\u043e \u043a\u0440\u043e\u043c\u0435 \u0443\u0434\u043e\u0431\u0441\u0442\u0432\u0430 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u0438\u044f \u044d\u0442\u0438 \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u043f\u043e\u0442\u0435\u043d\u0446\u0438\u0430\u043b\u044c\u043d\u043e (\u0441\u0430\u043c \u043d\u0435 \u043c\u0435\u0440\u044f\u043b \u0435\u0449\u0435) \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0442 \u0431\u044b\u0441\u0442\u0440\u0435\u0435, \u0442\u0430\u043a \u043a\u0430\u043a \u0434\u043b\u044f \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043d\u0443\u0436\u0435\u043d \u0432\u0441\u0435\u0433\u043e \u043e\u0434\u043d\u043e \u0441\u043a\u0430\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0432\u043c\u0435\u0441\u0442\u043e \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u044e\u0442\u0441\u044f \u0432 \u0441\u043b\u0443\u0447\u0430\u0435 UNION ALL<\/b>.<\/p>\n
  \u0421\u043f\u0430\u0441\u0438\u0431\u043e \u0437\u0430 \u0432\u043d\u0438\u043c\u0430\u043d\u0438\u0435!               <\/p>\n
<\/div>\n
 \u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b \u0441\u0442\u0430\u0442\u044c\u0438  http:\/\/habrahabr.ru\/post\/269849\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
       \u041f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u0435\u043c \u0437\u043d\u0430\u043a\u043e\u043c\u0438\u0442\u044c\u0441\u044f \u0441 \u043d\u043e\u0432\u044b\u043c\u0438 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044f\u043c\u0438 \u0432 PostgreSQL 9.5. 
  \u0427\u0430\u0441\u0442\u044c 1. INSERT\u2026 ON CONFLICT DO NOTHING\/UPDATE \u0438 ROW LEVEL SECURITY<\/a>
  \u0427\u0430\u0441\u0442\u044c 2. TABLESAMPLE<\/a>
  \u0421\u0435\u0433\u043e\u0434\u043d\u044f \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0435 \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0438 \u0432 \u043e\u0434\u043d\u043e\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435. \u042d\u0442\u0430 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0431\u044b\u043b\u0430 \u043e\u043f\u0438\u0441\u0430\u043d\u0430 \u0435\u0449\u0435 \u0432 \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u0435 SQL-99. \u0415\u0451 \u0443\u0434\u043e\u0431\u043d\u043e \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u0442\u044c \u0432 \u0442\u043e\u043c \u0441\u043b\u0443\u0447\u0430\u0435, \u0435\u0441\u043b\u0438 \u0432\u0430\u043c \u043d\u0443\u0436\u043d\u043e \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043a \u043e\u0434\u043d\u043e\u0439 \u0438 \u0442\u043e\u0439 \u0436\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u0435, \u043e\u0442\u043b\u0438\u0447\u0430\u044e\u0449\u0438\u0445\u0441\u044f \u0442\u043e\u043b\u044c\u043a\u043e \u0443\u0441\u043b\u043e\u0432\u0438\u0435\u043c \u0432 GROUP BY<\/b>. \u0414\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u043c\u043e\u0434\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440\u044b GROUPING SETS, ROLLUP, CUBE<\/b> \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u044e\u0442\u0441\u044f \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430 \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0438 \u043f\u043e\u0441\u043b\u0435 \u043a\u043b\u044e\u0447\u0435\u0432\u043e\u0433\u043e \u0441\u043b\u043e\u0432\u0430 GROUP BY<\/b>.
  \u0414\u0430\u0432\u0430\u0439\u0442\u0435 \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043f\u043e\u0431\u043b\u0438\u0436\u0435, \u043a\u0430\u043a \u044d\u0442\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442.  <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-267170","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/267170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=267170"}],"version-history":[{"count":0,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/267170\/revisions"}],"wp:attachment":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=267170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=267170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=267170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}