armen.sql

CREATE TABLE SUBJECT1 (
    NAME VARCHAR(100),
    SURNAME VARCHAR(100),
    CITY VARCHAR(100)
);

INSERT INTO SUBJECT1
SELECT NAME, SURNAME, CITY
FROM SUBJECT
GROUP BY NAME, SURNAME, CITY;


SELECT
    AGREEMENT.VID_STRAHOVANIYA,
    100 * COUNT(
        CHILD.DATESTART >= '2017-01-01'
        AND
        CHILD.DATESTART <= '2017-12-31'
    ) / COUNT(*)
FROM AGREEMENT
INNER JOIN AGREEMENT
    ON CHILD.PARENTISN = AGREEMENT.ISN
GROUP BY AGREEMENT.VID_STRAHOVANIYA;


UPDATE PROVODKA SET CODE = 'TEMP' WHERE CODE = '20501';
UPDATE PROVODKA SET CODE = '2501' WHERE CODE = '20502';
UPDATE PROVODKA SET CODE = '2502' WHERE CODE = 'TEMP';

-- Count days of week in a given year
WITH RECURSIVE alldays(theday) AS (
  SELECT date '2018-01-01'     -- Seed Row
  UNION ALL
  SELECT theday + interval 1 day -- Recursion
  FROM alldays
  WHERE v < date '2019-01-01'
)
SELECT dayofweek, COUNT(*)
FROM (SELECT to_char(theday, 'day') AS dayofweek FROM alldays)
GROUP BY dayofweek; 
-- SQLite version:
WITH RECURSIVE alldays(theday) AS (
    SELECT date('2018-01-01') UNION ALL
    SELECT date(theday, '+1 day') newday FROM alldays WHERE newday<'2019-01-01')
SELECT strftime('%w',theday) dow, COUNT(*)
FROM alldays
GROUP BY dow;