DROP TABLE IF EXISTS empsalary;
CREATE TABLE empsalary(
  depname varchar,
  empno bigint,
  salary int,
  enroll_date date
);
INSERT INTO empsalary VALUES('develop',10, 5200, '2007/08/01');
INSERT INTO empsalary VALUES('sales', 1, 5000, '2006/10/01');
INSERT INTO empsalary VALUES('personnel', 5, 3500, '2007/12/10');
INSERT INTO empsalary VALUES('sales', 4, 4800, '2007/08/08');
INSERT INTO empsalary VALUES('sales', 6, 5500, '2007/01/02');
INSERT INTO empsalary VALUES('personnel', 2, 3900, '2006/12/23');
INSERT INTO empsalary VALUES('develop', 7, 4200, '2008/01/01');
INSERT INTO empsalary VALUES('develop', 9, 4500, '2008/01/01');
INSERT INTO empsalary VALUES('sales', 3, 4800, '2007/08/01');
INSERT INTO empsalary VALUES('develop', 8, 6000, '2006/10/01');
INSERT INTO empsalary VALUES('develop', 11, 5200, '2007/08/15');

SELECT 
  depname,
  empno,
  salary,
  sum(salary) OVER (PARTITION BY depname)
FROM 
  empsalary;

SELECT
  depname,
  empno,
  salary,
  rank() OVER (PARTITION BY depname ORDER BY salary)
FROM
  empsalary;

DROP TABLE IF EXISTS accident;

CREATE TABLE accident(
  accident_date date,
  people int
);
INSERT INTO accident VALUES('2005/1/1', 3);
INSERT INTO accident VALUES('2005/1/2', 4);
INSERT INTO accident VALUES('2005/1/3', 0);
INSERT INTO accident VALUES('2005/1/4', 3);
INSERT INTO accident VALUES('2005/1/5', 0);
INSERT INTO accident VALUES('2005/1/6', 5);
INSERT INTO accident VALUES('2005/1/7', 5);
INSERT INTO accident VALUES('2005/1/8', 6);
INSERT INTO accident VALUES('2005/1/9', 7);
INSERT INTO accident VALUES('2005/1/10', 0);
INSERT INTO accident VALUES('2005/1/11', 10);
INSERT INTO accident VALUES('2005/1/12', 1);
INSERT INTO accident VALUES('2005/1/13', 1);
INSERT INTO accident VALUES('2005/1/14', 5);
INSERT INTO accident VALUES('2005/1/15', 1);
INSERT INTO accident VALUES('2005/1/16', 2);
INSERT INTO accident VALUES('2005/1/17', 8);
INSERT INTO accident VALUES('2005/1/18', 7);
INSERT INTO accident VALUES('2005/1/19', 3);
INSERT INTO accident VALUES('2005/1/20', 7);
INSERT INTO accident VALUES('2005/1/21', 0);
INSERT INTO accident VALUES('2005/1/22', 0);
INSERT INTO accident VALUES('2005/1/23', 1);
INSERT INTO accident VALUES('2005/1/24', 2);
INSERT INTO accident VALUES('2005/1/25', 1);
INSERT INTO accident VALUES('2005/1/26', 4);
INSERT INTO accident VALUES('2005/1/27', 3);
INSERT INTO accident VALUES('2005/1/28', 8);
INSERT INTO accident VALUES('2005/1/29', 0);
INSERT INTO accident VALUES('2005/1/30', 2);
INSERT INTO accident VALUES('2005/1/31', 10);
INSERT INTO accident VALUES('2005/2/1', 7);
INSERT INTO accident VALUES('2005/2/2', 6);
INSERT INTO accident VALUES('2005/2/3', 6);
INSERT INTO accident VALUES('2005/2/4', 4);
INSERT INTO accident VALUES('2005/2/5', 4);
INSERT INTO accident VALUES('2005/2/6', 10);
INSERT INTO accident VALUES('2005/2/7', 1);
INSERT INTO accident VALUES('2005/2/8', 9);
INSERT INTO accident VALUES('2005/2/9', 9);
INSERT INTO accident VALUES('2005/2/10', 7);
INSERT INTO accident VALUES('2005/2/11', 1);
INSERT INTO accident VALUES('2005/2/12', 7);
INSERT INTO accident VALUES('2005/2/13', 3);
INSERT INTO accident VALUES('2005/2/14', 7);
INSERT INTO accident VALUES('2005/2/15', 6);
INSERT INTO accident VALUES('2005/2/16', 5);
INSERT INTO accident VALUES('2005/2/17', 5);
INSERT INTO accident VALUES('2005/2/18', 0);
INSERT INTO accident VALUES('2005/2/19', 2);
INSERT INTO accident VALUES('2005/2/20', 5);
INSERT INTO accident VALUES('2005/2/21', 0);
INSERT INTO accident VALUES('2005/2/22', 5);
INSERT INTO accident VALUES('2005/2/23', 3);
INSERT INTO accident VALUES('2005/2/24', 8);
INSERT INTO accident VALUES('2005/2/25', 3);
INSERT INTO accident VALUES('2005/2/26', 5);
INSERT INTO accident VALUES('2005/2/27', 5);
INSERT INTO accident VALUES('2005/2/28', 4);
INSERT INTO accident VALUES('2005/3/1', 8);
INSERT INTO accident VALUES('2005/3/2', 1);
INSERT INTO accident VALUES('2005/3/3', 10);
INSERT INTO accident VALUES('2005/3/4', 2);
INSERT INTO accident VALUES('2005/3/5', 9);
INSERT INTO accident VALUES('2005/3/6', 3);
INSERT INTO accident VALUES('2005/3/7', 7);
INSERT INTO accident VALUES('2005/3/8', 0);
INSERT INTO accident VALUES('2005/3/9', 0);
INSERT INTO accident VALUES('2005/3/10', 7);
INSERT INTO accident VALUES('2005/3/11', 2);
INSERT INTO accident VALUES('2005/3/12', 0);
INSERT INTO accident VALUES('2005/3/13', 2);
INSERT INTO accident VALUES('2005/3/14', 7);
INSERT INTO accident VALUES('2005/3/15', 3);
INSERT INTO accident VALUES('2005/3/16', 7);
INSERT INTO accident VALUES('2005/3/17', 3);
INSERT INTO accident VALUES('2005/3/18', 1);
INSERT INTO accident VALUES('2005/3/19', 7);
INSERT INTO accident VALUES('2005/3/20', 7);
INSERT INTO accident VALUES('2005/3/21', 1);
INSERT INTO accident VALUES('2005/3/22', 2);
INSERT INTO accident VALUES('2005/3/23', 5);
INSERT INTO accident VALUES('2005/3/24', 7);
INSERT INTO accident VALUES('2005/3/25', 6);
INSERT INTO accident VALUES('2005/3/26', 5);
INSERT INTO accident VALUES('2005/3/27', 0);
INSERT INTO accident VALUES('2005/3/28', 5);
INSERT INTO accident VALUES('2005/3/29', 6);
INSERT INTO accident VALUES('2005/3/30', 5);
INSERT INTO accident VALUES('2005/3/31', 8);
INSERT INTO accident VALUES('2005/4/1', 3);
INSERT INTO accident VALUES('2005/4/2', 5);
INSERT INTO accident VALUES('2005/4/3', 7);
INSERT INTO accident VALUES('2005/4/4', 10);
INSERT INTO accident VALUES('2005/4/5', 0);
INSERT INTO accident VALUES('2005/4/6', 10);
INSERT INTO accident VALUES('2005/4/7', 6);
INSERT INTO accident VALUES('2005/4/8', 6);
INSERT INTO accident VALUES('2005/4/9', 2);
INSERT INTO accident VALUES('2005/4/10', 0);
INSERT INTO accident VALUES('2005/4/11', 0);
INSERT INTO accident VALUES('2005/4/12', 6);
INSERT INTO accident VALUES('2005/4/13', 0);
INSERT INTO accident VALUES('2005/4/14', 1);
INSERT INTO accident VALUES('2005/4/15', 7);
INSERT INTO accident VALUES('2005/4/16', 7);
INSERT INTO accident VALUES('2005/4/17', 0);
INSERT INTO accident VALUES('2005/4/18', 9);
INSERT INTO accident VALUES('2005/4/19', 8);
INSERT INTO accident VALUES('2005/4/20', 10);
INSERT INTO accident VALUES('2005/4/21', 10);
INSERT INTO accident VALUES('2005/4/22', 1);
INSERT INTO accident VALUES('2005/4/23', 4);
INSERT INTO accident VALUES('2005/4/24', 1);
INSERT INTO accident VALUES('2005/4/25', 6);
INSERT INTO accident VALUES('2005/4/26', 0);
INSERT INTO accident VALUES('2005/4/27', 4);
INSERT INTO accident VALUES('2005/4/28', 10);
INSERT INTO accident VALUES('2005/4/29', 4);
INSERT INTO accident VALUES('2005/4/30', 5);
INSERT INTO accident VALUES('2005/5/1', 5);
INSERT INTO accident VALUES('2005/5/2', 4);
INSERT INTO accident VALUES('2005/5/3', 4);
INSERT INTO accident VALUES('2005/5/4', 6);
INSERT INTO accident VALUES('2005/5/5', 1);
INSERT INTO accident VALUES('2005/5/6', 6);
INSERT INTO accident VALUES('2005/5/7', 6);
INSERT INTO accident VALUES('2005/5/8', 2);
INSERT INTO accident VALUES('2005/5/9', 8);
INSERT INTO accident VALUES('2005/5/10', 6);
INSERT INTO accident VALUES('2005/5/11', 4);
INSERT INTO accident VALUES('2005/5/12', 3);
INSERT INTO accident VALUES('2005/5/13', 7);
INSERT INTO accident VALUES('2005/5/14', 5);
INSERT INTO accident VALUES('2005/5/15', 5);
INSERT INTO accident VALUES('2005/5/16', 10);
INSERT INTO accident VALUES('2005/5/17', 6);
INSERT INTO accident VALUES('2005/5/18', 9);
INSERT INTO accident VALUES('2005/5/19', 7);
INSERT INTO accident VALUES('2005/5/20', 7);
INSERT INTO accident VALUES('2005/5/21', 1);
INSERT INTO accident VALUES('2005/5/22', 5);
INSERT INTO accident VALUES('2005/5/23', 10);
INSERT INTO accident VALUES('2005/5/24', 7);
INSERT INTO accident VALUES('2005/5/25', 0);
INSERT INTO accident VALUES('2005/5/26', 1);
INSERT INTO accident VALUES('2005/5/27', 3);
INSERT INTO accident VALUES('2005/5/28', 4);
INSERT INTO accident VALUES('2005/5/29', 7);
INSERT INTO accident VALUES('2005/5/30', 3);
INSERT INTO accident VALUES('2005/5/31', 6);
INSERT INTO accident VALUES('2005/6/1', 0);
INSERT INTO accident VALUES('2005/6/2', 10);
INSERT INTO accident VALUES('2005/6/3', 2);
INSERT INTO accident VALUES('2005/6/4', 3);
INSERT INTO accident VALUES('2005/6/5', 3);
INSERT INTO accident VALUES('2005/6/6', 9);
INSERT INTO accident VALUES('2005/6/7', 9);
INSERT INTO accident VALUES('2005/6/8', 7);
INSERT INTO accident VALUES('2005/6/9', 3);
INSERT INTO accident VALUES('2005/6/10', 8);
INSERT INTO accident VALUES('2005/6/11', 10);
INSERT INTO accident VALUES('2005/6/12', 4);
INSERT INTO accident VALUES('2005/6/13', 3);
INSERT INTO accident VALUES('2005/6/14', 8);
INSERT INTO accident VALUES('2005/6/15', 8);
INSERT INTO accident VALUES('2005/6/16', 8);
INSERT INTO accident VALUES('2005/6/17', 2);
INSERT INTO accident VALUES('2005/6/18', 7);
INSERT INTO accident VALUES('2005/6/19', 3);
INSERT INTO accident VALUES('2005/6/20', 8);
INSERT INTO accident VALUES('2005/6/21', 1);
INSERT INTO accident VALUES('2005/6/22', 3);
INSERT INTO accident VALUES('2005/6/23', 1);
INSERT INTO accident VALUES('2005/6/24', 9);
INSERT INTO accident VALUES('2005/6/25', 10);
INSERT INTO accident VALUES('2005/6/26', 0);
INSERT INTO accident VALUES('2005/6/27', 9);
INSERT INTO accident VALUES('2005/6/28', 2);
INSERT INTO accident VALUES('2005/6/29', 0);
INSERT INTO accident VALUES('2005/6/30', 8);
INSERT INTO accident VALUES('2005/7/1', 9);
INSERT INTO accident VALUES('2005/7/2', 6);
INSERT INTO accident VALUES('2005/7/3', 5);
INSERT INTO accident VALUES('2005/7/4', 1);
INSERT INTO accident VALUES('2005/7/5', 4);
INSERT INTO accident VALUES('2005/7/6', 7);
INSERT INTO accident VALUES('2005/7/7', 1);
INSERT INTO accident VALUES('2005/7/8', 0);
INSERT INTO accident VALUES('2005/7/9', 3);
INSERT INTO accident VALUES('2005/7/10', 6);
INSERT INTO accident VALUES('2005/7/11', 7);
INSERT INTO accident VALUES('2005/7/12', 8);
INSERT INTO accident VALUES('2005/7/13', 6);
INSERT INTO accident VALUES('2005/7/14', 8);
INSERT INTO accident VALUES('2005/7/15', 3);
INSERT INTO accident VALUES('2005/7/16', 9);
INSERT INTO accident VALUES('2005/7/17', 7);
INSERT INTO accident VALUES('2005/7/18', 4);
INSERT INTO accident VALUES('2005/7/19', 4);
INSERT INTO accident VALUES('2005/7/20', 7);
INSERT INTO accident VALUES('2005/7/21', 9);
INSERT INTO accident VALUES('2005/7/22', 0);
INSERT INTO accident VALUES('2005/7/23', 5);
INSERT INTO accident VALUES('2005/7/24', 0);
INSERT INTO accident VALUES('2005/7/25', 3);
INSERT INTO accident VALUES('2005/7/26', 1);
INSERT INTO accident VALUES('2005/7/27', 7);
INSERT INTO accident VALUES('2005/7/28', 10);
INSERT INTO accident VALUES('2005/7/29', 2);
INSERT INTO accident VALUES('2005/7/30', 1);
INSERT INTO accident VALUES('2005/7/31', 8);
INSERT INTO accident VALUES('2005/8/1', 1);
INSERT INTO accident VALUES('2005/8/2', 4);
INSERT INTO accident VALUES('2005/8/3', 9);
INSERT INTO accident VALUES('2005/8/4', 8);
INSERT INTO accident VALUES('2005/8/5', 3);
INSERT INTO accident VALUES('2005/8/6', 9);
INSERT INTO accident VALUES('2005/8/7', 8);
INSERT INTO accident VALUES('2005/8/8', 0);
INSERT INTO accident VALUES('2005/8/9', 5);
INSERT INTO accident VALUES('2005/8/10', 9);
INSERT INTO accident VALUES('2005/8/11', 1);
INSERT INTO accident VALUES('2005/8/12', 1);
INSERT INTO accident VALUES('2005/8/13', 6);
INSERT INTO accident VALUES('2005/8/14', 6);
INSERT INTO accident VALUES('2005/8/15', 10);
INSERT INTO accident VALUES('2005/8/16', 0);
INSERT INTO accident VALUES('2005/8/17', 5);
INSERT INTO accident VALUES('2005/8/18', 8);
INSERT INTO accident VALUES('2005/8/19', 3);
INSERT INTO accident VALUES('2005/8/20', 6);
INSERT INTO accident VALUES('2005/8/21', 4);
INSERT INTO accident VALUES('2005/8/22', 1);
INSERT INTO accident VALUES('2005/8/23', 9);
INSERT INTO accident VALUES('2005/8/24', 6);
INSERT INTO accident VALUES('2005/8/25', 4);
INSERT INTO accident VALUES('2005/8/26', 0);
INSERT INTO accident VALUES('2005/8/27', 9);
INSERT INTO accident VALUES('2005/8/28', 6);
INSERT INTO accident VALUES('2005/8/29', 2);
INSERT INTO accident VALUES('2005/8/30', 4);
INSERT INTO accident VALUES('2005/8/31', 0);
INSERT INTO accident VALUES('2005/9/1', 10);
INSERT INTO accident VALUES('2005/9/2', 0);
INSERT INTO accident VALUES('2005/9/3', 10);
INSERT INTO accident VALUES('2005/9/4', 10);
INSERT INTO accident VALUES('2005/9/5', 6);
INSERT INTO accident VALUES('2005/9/6', 7);
INSERT INTO accident VALUES('2005/9/7', 0);
INSERT INTO accident VALUES('2005/9/8', 1);
INSERT INTO accident VALUES('2005/9/9', 7);
INSERT INTO accident VALUES('2005/9/10', 5);
INSERT INTO accident VALUES('2005/9/11', 0);
INSERT INTO accident VALUES('2005/9/12', 4);
INSERT INTO accident VALUES('2005/9/13', 0);
INSERT INTO accident VALUES('2005/9/14', 7);
INSERT INTO accident VALUES('2005/9/15', 10);
INSERT INTO accident VALUES('2005/9/16', 3);
INSERT INTO accident VALUES('2005/9/17', 2);
INSERT INTO accident VALUES('2005/9/18', 3);
INSERT INTO accident VALUES('2005/9/19', 8);
INSERT INTO accident VALUES('2005/9/20', 0);
INSERT INTO accident VALUES('2005/9/21', 5);
INSERT INTO accident VALUES('2005/9/22', 8);
INSERT INTO accident VALUES('2005/9/23', 6);
INSERT INTO accident VALUES('2005/9/24', 1);
INSERT INTO accident VALUES('2005/9/25', 9);
INSERT INTO accident VALUES('2005/9/26', 0);
INSERT INTO accident VALUES('2005/9/27', 2);
INSERT INTO accident VALUES('2005/9/28', 8);
INSERT INTO accident VALUES('2005/9/29', 5);
INSERT INTO accident VALUES('2005/9/30', 7);
INSERT INTO accident VALUES('2005/10/1', 3);
INSERT INTO accident VALUES('2005/10/2', 0);
INSERT INTO accident VALUES('2005/10/3', 3);
INSERT INTO accident VALUES('2005/10/4', 8);
INSERT INTO accident VALUES('2005/10/5', 6);
INSERT INTO accident VALUES('2005/10/6', 4);
INSERT INTO accident VALUES('2005/10/7', 6);
INSERT INTO accident VALUES('2005/10/8', 3);
INSERT INTO accident VALUES('2005/10/9', 9);
INSERT INTO accident VALUES('2005/10/10', 6);
INSERT INTO accident VALUES('2005/10/11', 2);
INSERT INTO accident VALUES('2005/10/12', 5);
INSERT INTO accident VALUES('2005/10/13', 6);
INSERT INTO accident VALUES('2005/10/14', 7);
INSERT INTO accident VALUES('2005/10/15', 7);
INSERT INTO accident VALUES('2005/10/16', 5);
INSERT INTO accident VALUES('2005/10/17', 1);
INSERT INTO accident VALUES('2005/10/18', 0);
INSERT INTO accident VALUES('2005/10/19', 5);
INSERT INTO accident VALUES('2005/10/20', 10);
INSERT INTO accident VALUES('2005/10/21', 4);
INSERT INTO accident VALUES('2005/10/22', 5);
INSERT INTO accident VALUES('2005/10/23', 1);
INSERT INTO accident VALUES('2005/10/24', 6);
INSERT INTO accident VALUES('2005/10/25', 2);
INSERT INTO accident VALUES('2005/10/26', 9);
INSERT INTO accident VALUES('2005/10/27', 9);
INSERT INTO accident VALUES('2005/10/28', 2);
INSERT INTO accident VALUES('2005/10/29', 8);
INSERT INTO accident VALUES('2005/10/30', 7);
INSERT INTO accident VALUES('2005/10/31', 2);
INSERT INTO accident VALUES('2005/11/1', 4);
INSERT INTO accident VALUES('2005/11/2', 10);
INSERT INTO accident VALUES('2005/11/3', 9);
INSERT INTO accident VALUES('2005/11/4', 3);
INSERT INTO accident VALUES('2005/11/5', 2);
INSERT INTO accident VALUES('2005/11/6', 5);
INSERT INTO accident VALUES('2005/11/7', 1);
INSERT INTO accident VALUES('2005/11/8', 2);
INSERT INTO accident VALUES('2005/11/9', 1);
INSERT INTO accident VALUES('2005/11/10', 8);
INSERT INTO accident VALUES('2005/11/11', 6);
INSERT INTO accident VALUES('2005/11/12', 2);
INSERT INTO accident VALUES('2005/11/13', 2);
INSERT INTO accident VALUES('2005/11/14', 1);
INSERT INTO accident VALUES('2005/11/15', 8);
INSERT INTO accident VALUES('2005/11/16', 2);
INSERT INTO accident VALUES('2005/11/17', 7);
INSERT INTO accident VALUES('2005/11/18', 10);
INSERT INTO accident VALUES('2005/11/19', 10);
INSERT INTO accident VALUES('2005/11/20', 9);
INSERT INTO accident VALUES('2005/11/21', 1);
INSERT INTO accident VALUES('2005/11/22', 8);
INSERT INTO accident VALUES('2005/11/23', 1);
INSERT INTO accident VALUES('2005/11/24', 1);
INSERT INTO accident VALUES('2005/11/25', 2);
INSERT INTO accident VALUES('2005/11/26', 3);
INSERT INTO accident VALUES('2005/11/27', 5);
INSERT INTO accident VALUES('2005/11/28', 1);
INSERT INTO accident VALUES('2005/11/29', 0);
INSERT INTO accident VALUES('2005/11/30', 0);
INSERT INTO accident VALUES('2005/12/1', 8);
INSERT INTO accident VALUES('2005/12/2', 6);
INSERT INTO accident VALUES('2005/12/3', 0);
INSERT INTO accident VALUES('2005/12/4', 6);
INSERT INTO accident VALUES('2005/12/5', 6);
INSERT INTO accident VALUES('2005/12/6', 1);
INSERT INTO accident VALUES('2005/12/7', 8);
INSERT INTO accident VALUES('2005/12/8', 6);
INSERT INTO accident VALUES('2005/12/9', 2);
INSERT INTO accident VALUES('2005/12/10', 0);
INSERT INTO accident VALUES('2005/12/11', 10);
INSERT INTO accident VALUES('2005/12/12', 10);
INSERT INTO accident VALUES('2005/12/13', 0);
INSERT INTO accident VALUES('2005/12/14', 9);
INSERT INTO accident VALUES('2005/12/15', 1);
INSERT INTO accident VALUES('2005/12/16', 3);
INSERT INTO accident VALUES('2005/12/17', 0);
INSERT INTO accident VALUES('2005/12/18', 4);
INSERT INTO accident VALUES('2005/12/19', 4);
INSERT INTO accident VALUES('2005/12/20', 10);
INSERT INTO accident VALUES('2005/12/21', 5);
INSERT INTO accident VALUES('2005/12/22', 9);
INSERT INTO accident VALUES('2005/12/23', 2);
INSERT INTO accident VALUES('2005/12/24', 2);
INSERT INTO accident VALUES('2005/12/25', 5);
INSERT INTO accident VALUES('2005/12/26', 5);
INSERT INTO accident VALUES('2005/12/27', 6);
INSERT INTO accident VALUES('2005/12/28', 2);
INSERT INTO accident VALUES('2005/12/29', 1);
INSERT INTO accident VALUES('2005/12/30', 2);
INSERT INTO accident VALUES('2005/12/31', 8);
INSERT INTO accident VALUES('2006/1/1', 0);
INSERT INTO accident VALUES('2006/1/2', 0);
INSERT INTO accident VALUES('2006/1/3', 1);
INSERT INTO accident VALUES('2006/1/4', 7);
INSERT INTO accident VALUES('2006/1/5', 2);
INSERT INTO accident VALUES('2006/1/6', 5);
INSERT INTO accident VALUES('2006/1/7', 10);
INSERT INTO accident VALUES('2006/1/8', 5);
INSERT INTO accident VALUES('2006/1/9', 8);
INSERT INTO accident VALUES('2006/1/10', 8);
INSERT INTO accident VALUES('2006/1/11', 6);
INSERT INTO accident VALUES('2006/1/12', 4);
INSERT INTO accident VALUES('2006/1/13', 2);
INSERT INTO accident VALUES('2006/1/14', 9);
INSERT INTO accident VALUES('2006/1/15', 0);
INSERT INTO accident VALUES('2006/1/16', 7);
INSERT INTO accident VALUES('2006/1/17', 5);
INSERT INTO accident VALUES('2006/1/18', 6);
INSERT INTO accident VALUES('2006/1/19', 8);
INSERT INTO accident VALUES('2006/1/20', 0);
INSERT INTO accident VALUES('2006/1/21', 4);
INSERT INTO accident VALUES('2006/1/22', 10);
INSERT INTO accident VALUES('2006/1/23', 2);
INSERT INTO accident VALUES('2006/1/24', 1);
INSERT INTO accident VALUES('2006/1/25', 9);
INSERT INTO accident VALUES('2006/1/26', 0);
INSERT INTO accident VALUES('2006/1/27', 7);
INSERT INTO accident VALUES('2006/1/28', 4);
INSERT INTO accident VALUES('2006/1/29', 1);
INSERT INTO accident VALUES('2006/1/30', 5);
INSERT INTO accident VALUES('2006/1/31', 0);
INSERT INTO accident VALUES('2006/2/1', 3);
INSERT INTO accident VALUES('2006/2/2', 8);
INSERT INTO accident VALUES('2006/2/3', 7);
INSERT INTO accident VALUES('2006/2/4', 4);
INSERT INTO accident VALUES('2006/2/5', 9);
INSERT INTO accident VALUES('2006/2/6', 7);
INSERT INTO accident VALUES('2006/2/7', 0);
INSERT INTO accident VALUES('2006/2/8', 8);
INSERT INTO accident VALUES('2006/2/9', 0);
INSERT INTO accident VALUES('2006/2/10', 8);
INSERT INTO accident VALUES('2006/2/11', 2);
INSERT INTO accident VALUES('2006/2/12', 5);
INSERT INTO accident VALUES('2006/2/13', 9);
INSERT INTO accident VALUES('2006/2/14', 4);
INSERT INTO accident VALUES('2006/2/15', 7);
INSERT INTO accident VALUES('2006/2/16', 1);
INSERT INTO accident VALUES('2006/2/17', 5);
INSERT INTO accident VALUES('2006/2/18', 6);
INSERT INTO accident VALUES('2006/2/19', 2);
INSERT INTO accident VALUES('2006/2/20', 4);
INSERT INTO accident VALUES('2006/2/21', 8);
INSERT INTO accident VALUES('2006/2/22', 1);
INSERT INTO accident VALUES('2006/2/23', 2);
INSERT INTO accident VALUES('2006/2/24', 3);
INSERT INTO accident VALUES('2006/2/25', 9);
INSERT INTO accident VALUES('2006/2/26', 2);
INSERT INTO accident VALUES('2006/2/27', 2);
INSERT INTO accident VALUES('2006/2/28', 0);
INSERT INTO accident VALUES('2006/3/1', 7);
INSERT INTO accident VALUES('2006/3/2', 0);
INSERT INTO accident VALUES('2006/3/3', 6);
INSERT INTO accident VALUES('2006/3/4', 2);
INSERT INTO accident VALUES('2006/3/5', 10);
INSERT INTO accident VALUES('2006/3/6', 10);
INSERT INTO accident VALUES('2006/3/7', 1);
INSERT INTO accident VALUES('2006/3/8', 1);
INSERT INTO accident VALUES('2006/3/9', 8);
INSERT INTO accident VALUES('2006/3/10', 0);
INSERT INTO accident VALUES('2006/3/11', 0);
INSERT INTO accident VALUES('2006/3/12', 6);
INSERT INTO accident VALUES('2006/3/13', 6);
INSERT INTO accident VALUES('2006/3/14', 3);
INSERT INTO accident VALUES('2006/3/15', 7);
INSERT INTO accident VALUES('2006/3/16', 6);
INSERT INTO accident VALUES('2006/3/17', 7);
INSERT INTO accident VALUES('2006/3/18', 10);
INSERT INTO accident VALUES('2006/3/19', 0);
INSERT INTO accident VALUES('2006/3/20', 4);
INSERT INTO accident VALUES('2006/3/21', 9);
INSERT INTO accident VALUES('2006/3/22', 5);
INSERT INTO accident VALUES('2006/3/23', 2);
INSERT INTO accident VALUES('2006/3/24', 3);
INSERT INTO accident VALUES('2006/3/25', 3);
INSERT INTO accident VALUES('2006/3/26', 3);
INSERT INTO accident VALUES('2006/3/27', 7);
INSERT INTO accident VALUES('2006/3/28', 8);
INSERT INTO accident VALUES('2006/3/29', 7);
INSERT INTO accident VALUES('2006/3/30', 9);
INSERT INTO accident VALUES('2006/3/31', 0);
INSERT INTO accident VALUES('2006/4/1', 6);
INSERT INTO accident VALUES('2006/4/2', 1);
INSERT INTO accident VALUES('2006/4/3', 4);
INSERT INTO accident VALUES('2006/4/4', 4);
INSERT INTO accident VALUES('2006/4/5', 4);
INSERT INTO accident VALUES('2006/4/6', 5);
INSERT INTO accident VALUES('2006/4/7', 1);
INSERT INTO accident VALUES('2006/4/8', 0);
INSERT INTO accident VALUES('2006/4/9', 7);
INSERT INTO accident VALUES('2006/4/10', 8);
INSERT INTO accident VALUES('2006/4/11', 8);
INSERT INTO accident VALUES('2006/4/12', 6);
INSERT INTO accident VALUES('2006/4/13', 7);
INSERT INTO accident VALUES('2006/4/14', 10);
INSERT INTO accident VALUES('2006/4/15', 10);
INSERT INTO accident VALUES('2006/4/16', 10);
INSERT INTO accident VALUES('2006/4/17', 2);
INSERT INTO accident VALUES('2006/4/18', 0);
INSERT INTO accident VALUES('2006/4/19', 3);
INSERT INTO accident VALUES('2006/4/20', 0);
INSERT INTO accident VALUES('2006/4/21', 10);
INSERT INTO accident VALUES('2006/4/22', 1);
INSERT INTO accident VALUES('2006/4/23', 7);
INSERT INTO accident VALUES('2006/4/24', 10);
INSERT INTO accident VALUES('2006/4/25', 3);
INSERT INTO accident VALUES('2006/4/26', 10);
INSERT INTO accident VALUES('2006/4/27', 3);
INSERT INTO accident VALUES('2006/4/28', 0);
INSERT INTO accident VALUES('2006/4/29', 5);
INSERT INTO accident VALUES('2006/4/30', 6);
INSERT INTO accident VALUES('2006/5/1', 0);
INSERT INTO accident VALUES('2006/5/2', 4);
INSERT INTO accident VALUES('2006/5/3', 8);
INSERT INTO accident VALUES('2006/5/4', 9);
INSERT INTO accident VALUES('2006/5/5', 3);
INSERT INTO accident VALUES('2006/5/6', 1);
INSERT INTO accident VALUES('2006/5/7', 8);
INSERT INTO accident VALUES('2006/5/8', 7);
INSERT INTO accident VALUES('2006/5/9', 7);
INSERT INTO accident VALUES('2006/5/10', 1);
INSERT INTO accident VALUES('2006/5/11', 2);
INSERT INTO accident VALUES('2006/5/12', 8);
INSERT INTO accident VALUES('2006/5/13', 9);
INSERT INTO accident VALUES('2006/5/14', 1);
INSERT INTO accident VALUES('2006/5/15', 2);
INSERT INTO accident VALUES('2006/5/16', 3);
INSERT INTO accident VALUES('2006/5/17', 10);
INSERT INTO accident VALUES('2006/5/18', 0);
INSERT INTO accident VALUES('2006/5/19', 6);
INSERT INTO accident VALUES('2006/5/20', 10);
INSERT INTO accident VALUES('2006/5/21', 6);
INSERT INTO accident VALUES('2006/5/22', 4);
INSERT INTO accident VALUES('2006/5/23', 3);
INSERT INTO accident VALUES('2006/5/24', 1);
INSERT INTO accident VALUES('2006/5/25', 1);
INSERT INTO accident VALUES('2006/5/26', 4);
INSERT INTO accident VALUES('2006/5/27', 8);
INSERT INTO accident VALUES('2006/5/28', 7);
INSERT INTO accident VALUES('2006/5/29', 1);
INSERT INTO accident VALUES('2006/5/30', 5);
INSERT INTO accident VALUES('2006/5/31', 0);
INSERT INTO accident VALUES('2006/6/1', 1);
INSERT INTO accident VALUES('2006/6/2', 9);
INSERT INTO accident VALUES('2006/6/3', 6);
INSERT INTO accident VALUES('2006/6/4', 7);
INSERT INTO accident VALUES('2006/6/5', 1);
INSERT INTO accident VALUES('2006/6/6', 9);
INSERT INTO accident VALUES('2006/6/7', 1);
INSERT INTO accident VALUES('2006/6/8', 0);
INSERT INTO accident VALUES('2006/6/9', 1);
INSERT INTO accident VALUES('2006/6/10', 0);
INSERT INTO accident VALUES('2006/6/11', 5);
INSERT INTO accident VALUES('2006/6/12', 9);
INSERT INTO accident VALUES('2006/6/13', 2);
INSERT INTO accident VALUES('2006/6/14', 9);
INSERT INTO accident VALUES('2006/6/15', 9);
INSERT INTO accident VALUES('2006/6/16', 2);
INSERT INTO accident VALUES('2006/6/17', 1);
INSERT INTO accident VALUES('2006/6/18', 6);
INSERT INTO accident VALUES('2006/6/19', 0);
INSERT INTO accident VALUES('2006/6/20', 0);
INSERT INTO accident VALUES('2006/6/21', 9);
INSERT INTO accident VALUES('2006/6/22', 2);
INSERT INTO accident VALUES('2006/6/23', 1);
INSERT INTO accident VALUES('2006/6/24', 6);
INSERT INTO accident VALUES('2006/6/25', 4);
INSERT INTO accident VALUES('2006/6/26', 4);
INSERT INTO accident VALUES('2006/6/27', 9);
INSERT INTO accident VALUES('2006/6/28', 7);
INSERT INTO accident VALUES('2006/6/29', 3);
INSERT INTO accident VALUES('2006/6/30', 1);
INSERT INTO accident VALUES('2006/7/1', 10);
INSERT INTO accident VALUES('2006/7/2', 5);
INSERT INTO accident VALUES('2006/7/3', 8);
INSERT INTO accident VALUES('2006/7/4', 5);
INSERT INTO accident VALUES('2006/7/5', 2);
INSERT INTO accident VALUES('2006/7/6', 5);
INSERT INTO accident VALUES('2006/7/7', 10);
INSERT INTO accident VALUES('2006/7/8', 5);
INSERT INTO accident VALUES('2006/7/9', 2);
INSERT INTO accident VALUES('2006/7/10', 2);
INSERT INTO accident VALUES('2006/7/11', 8);
INSERT INTO accident VALUES('2006/7/12', 7);
INSERT INTO accident VALUES('2006/7/13', 6);
INSERT INTO accident VALUES('2006/7/14', 8);
INSERT INTO accident VALUES('2006/7/15', 9);
INSERT INTO accident VALUES('2006/7/16', 5);
INSERT INTO accident VALUES('2006/7/17', 5);
INSERT INTO accident VALUES('2006/7/18', 6);
INSERT INTO accident VALUES('2006/7/19', 8);
INSERT INTO accident VALUES('2006/7/20', 0);
INSERT INTO accident VALUES('2006/7/21', 8);
INSERT INTO accident VALUES('2006/7/22', 9);
INSERT INTO accident VALUES('2006/7/23', 5);
INSERT INTO accident VALUES('2006/7/24', 0);
INSERT INTO accident VALUES('2006/7/25', 4);
INSERT INTO accident VALUES('2006/7/26', 0);
INSERT INTO accident VALUES('2006/7/27', 5);
INSERT INTO accident VALUES('2006/7/28', 1);
INSERT INTO accident VALUES('2006/7/29', 9);
INSERT INTO accident VALUES('2006/7/30', 0);
INSERT INTO accident VALUES('2006/7/31', 4);
INSERT INTO accident VALUES('2006/8/1', 8);
INSERT INTO accident VALUES('2006/8/2', 3);
INSERT INTO accident VALUES('2006/8/3', 10);
INSERT INTO accident VALUES('2006/8/4', 5);
INSERT INTO accident VALUES('2006/8/5', 7);
INSERT INTO accident VALUES('2006/8/6', 1);
INSERT INTO accident VALUES('2006/8/7', 7);
INSERT INTO accident VALUES('2006/8/8', 8);
INSERT INTO accident VALUES('2006/8/9', 5);
INSERT INTO accident VALUES('2006/8/10', 0);
INSERT INTO accident VALUES('2006/8/11', 9);
INSERT INTO accident VALUES('2006/8/12', 6);
INSERT INTO accident VALUES('2006/8/13', 7);
INSERT INTO accident VALUES('2006/8/14', 8);
INSERT INTO accident VALUES('2006/8/15', 0);
INSERT INTO accident VALUES('2006/8/16', 5);
INSERT INTO accident VALUES('2006/8/17', 0);
INSERT INTO accident VALUES('2006/8/18', 5);
INSERT INTO accident VALUES('2006/8/19', 4);
INSERT INTO accident VALUES('2006/8/20', 0);
INSERT INTO accident VALUES('2006/8/21', 1);
INSERT INTO accident VALUES('2006/8/22', 0);
INSERT INTO accident VALUES('2006/8/23', 1);
INSERT INTO accident VALUES('2006/8/24', 4);
INSERT INTO accident VALUES('2006/8/25', 2);
INSERT INTO accident VALUES('2006/8/26', 4);
INSERT INTO accident VALUES('2006/8/27', 10);
INSERT INTO accident VALUES('2006/8/28', 10);
INSERT INTO accident VALUES('2006/8/29', 1);
INSERT INTO accident VALUES('2006/8/30', 6);
INSERT INTO accident VALUES('2006/8/31', 10);
INSERT INTO accident VALUES('2006/9/1', 4);
INSERT INTO accident VALUES('2006/9/2', 5);
INSERT INTO accident VALUES('2006/9/3', 9);
INSERT INTO accident VALUES('2006/9/4', 9);
INSERT INTO accident VALUES('2006/9/5', 0);
INSERT INTO accident VALUES('2006/9/6', 1);
INSERT INTO accident VALUES('2006/9/7', 0);
INSERT INTO accident VALUES('2006/9/8', 0);
INSERT INTO accident VALUES('2006/9/9', 5);
INSERT INTO accident VALUES('2006/9/10', 9);
INSERT INTO accident VALUES('2006/9/11', 5);
INSERT INTO accident VALUES('2006/9/12', 8);
INSERT INTO accident VALUES('2006/9/13', 7);
INSERT INTO accident VALUES('2006/9/14', 6);
INSERT INTO accident VALUES('2006/9/15', 4);
INSERT INTO accident VALUES('2006/9/16', 1);
INSERT INTO accident VALUES('2006/9/17', 1);
INSERT INTO accident VALUES('2006/9/18', 1);
INSERT INTO accident VALUES('2006/9/19', 0);
INSERT INTO accident VALUES('2006/9/20', 0);
INSERT INTO accident VALUES('2006/9/21', 4);
INSERT INTO accident VALUES('2006/9/22', 3);
INSERT INTO accident VALUES('2006/9/23', 9);
INSERT INTO accident VALUES('2006/9/24', 9);
INSERT INTO accident VALUES('2006/9/25', 1);
INSERT INTO accident VALUES('2006/9/26', 5);
INSERT INTO accident VALUES('2006/9/27', 3);
INSERT INTO accident VALUES('2006/9/28', 2);
INSERT INTO accident VALUES('2006/9/29', 4);
INSERT INTO accident VALUES('2006/9/30', 0);
INSERT INTO accident VALUES('2006/10/1', 7);
INSERT INTO accident VALUES('2006/10/2', 9);
INSERT INTO accident VALUES('2006/10/3', 7);
INSERT INTO accident VALUES('2006/10/4', 4);
INSERT INTO accident VALUES('2006/10/5', 3);
INSERT INTO accident VALUES('2006/10/6', 5);
INSERT INTO accident VALUES('2006/10/7', 7);
INSERT INTO accident VALUES('2006/10/8', 1);
INSERT INTO accident VALUES('2006/10/9', 7);
INSERT INTO accident VALUES('2006/10/10', 6);
INSERT INTO accident VALUES('2006/10/11', 2);
INSERT INTO accident VALUES('2006/10/12', 9);
INSERT INTO accident VALUES('2006/10/13', 5);
INSERT INTO accident VALUES('2006/10/14', 8);
INSERT INTO accident VALUES('2006/10/15', 7);
INSERT INTO accident VALUES('2006/10/16', 8);
INSERT INTO accident VALUES('2006/10/17', 9);
INSERT INTO accident VALUES('2006/10/18', 9);
INSERT INTO accident VALUES('2006/10/19', 5);
INSERT INTO accident VALUES('2006/10/20', 6);
INSERT INTO accident VALUES('2006/10/21', 3);
INSERT INTO accident VALUES('2006/10/22', 7);
INSERT INTO accident VALUES('2006/10/23', 10);
INSERT INTO accident VALUES('2006/10/24', 9);
INSERT INTO accident VALUES('2006/10/25', 5);
INSERT INTO accident VALUES('2006/10/26', 9);
INSERT INTO accident VALUES('2006/10/27', 2);
INSERT INTO accident VALUES('2006/10/28', 0);
INSERT INTO accident VALUES('2006/10/29', 5);
INSERT INTO accident VALUES('2006/10/30', 9);
INSERT INTO accident VALUES('2006/10/31', 10);
INSERT INTO accident VALUES('2006/11/1', 5);
INSERT INTO accident VALUES('2006/11/2', 4);
INSERT INTO accident VALUES('2006/11/3', 1);
INSERT INTO accident VALUES('2006/11/4', 2);
INSERT INTO accident VALUES('2006/11/5', 0);
INSERT INTO accident VALUES('2006/11/6', 1);
INSERT INTO accident VALUES('2006/11/7', 8);
INSERT INTO accident VALUES('2006/11/8', 2);
INSERT INTO accident VALUES('2006/11/9', 1);
INSERT INTO accident VALUES('2006/11/10', 7);
INSERT INTO accident VALUES('2006/11/11', 9);
INSERT INTO accident VALUES('2006/11/12', 7);
INSERT INTO accident VALUES('2006/11/13', 5);
INSERT INTO accident VALUES('2006/11/14', 1);
INSERT INTO accident VALUES('2006/11/15', 1);
INSERT INTO accident VALUES('2006/11/16', 8);
INSERT INTO accident VALUES('2006/11/17', 4);
INSERT INTO accident VALUES('2006/11/18', 0);
INSERT INTO accident VALUES('2006/11/19', 10);
INSERT INTO accident VALUES('2006/11/20', 7);
INSERT INTO accident VALUES('2006/11/21', 4);
INSERT INTO accident VALUES('2006/11/22', 4);
INSERT INTO accident VALUES('2006/11/23', 10);
INSERT INTO accident VALUES('2006/11/24', 6);
INSERT INTO accident VALUES('2006/11/25', 2);
INSERT INTO accident VALUES('2006/11/26', 9);
INSERT INTO accident VALUES('2006/11/27', 2);
INSERT INTO accident VALUES('2006/11/28', 3);
INSERT INTO accident VALUES('2006/11/29', 5);
INSERT INTO accident VALUES('2006/11/30', 5);
INSERT INTO accident VALUES('2006/12/1', 0);
INSERT INTO accident VALUES('2006/12/2', 4);
INSERT INTO accident VALUES('2006/12/3', 8);
INSERT INTO accident VALUES('2006/12/4', 0);
INSERT INTO accident VALUES('2006/12/5', 9);
INSERT INTO accident VALUES('2006/12/6', 10);
INSERT INTO accident VALUES('2006/12/7', 8);
INSERT INTO accident VALUES('2006/12/8', 10);
INSERT INTO accident VALUES('2006/12/9', 5);
INSERT INTO accident VALUES('2006/12/10', 7);
INSERT INTO accident VALUES('2006/12/11', 5);
INSERT INTO accident VALUES('2006/12/12', 9);
INSERT INTO accident VALUES('2006/12/13', 4);
INSERT INTO accident VALUES('2006/12/14', 0);
INSERT INTO accident VALUES('2006/12/15', 0);
INSERT INTO accident VALUES('2006/12/16', 8);
INSERT INTO accident VALUES('2006/12/17', 10);
INSERT INTO accident VALUES('2006/12/18', 10);
INSERT INTO accident VALUES('2006/12/19', 1);
INSERT INTO accident VALUES('2006/12/20', 3);
INSERT INTO accident VALUES('2006/12/21', 8);
INSERT INTO accident VALUES('2006/12/22', 1);
INSERT INTO accident VALUES('2006/12/23', 9);
INSERT INTO accident VALUES('2006/12/24', 10);
INSERT INTO accident VALUES('2006/12/25', 9);
INSERT INTO accident VALUES('2006/12/26', 0);
INSERT INTO accident VALUES('2006/12/27', 3);
INSERT INTO accident VALUES('2006/12/28', 7);
INSERT INTO accident VALUES('2006/12/29', 1);
INSERT INTO accident VALUES('2006/12/30', 1);
INSERT INTO accident VALUES('2006/12/31', 5);

SELECT
  y,
  m,
  SUM(SUM(people)) OVER (PARTITION BY y ORDER BY m),
  AVG(people)
FROM(
  SELECT
    EXTRACT(YEAR FROM accident_date) AS y,
    EXTRACT(MONTH FROM accident_date) AS m,
    *
  FROM
    accident
)s
GROUP BY y, m;