test.sql

sql

SELECT DISTINCT result.request_json->>'target' as target, 
                result.request_json->>'return_to' as return_to 
FROM (
  SELECT "request_params"::json as request_json 
  FROM "histories" 
  WHERE (created_at > '2018-12-05 00:00:00') AND
  (created_at < '2019-01-05 00:00:00')

) as result 
WHERE (
  result.request_json->>'target' IS NOT NULL 
  OR result.request_json->>'return_to' IS NOT NULL
);

SELECT DISTINCT result.request_json->>'target' as target, 
                result.request_json->>'return_to' as return_to 
FROM (
  SELECT "request_params"::json as request_json 
  FROM "histories" 
  WHERE (created_at > '2019-01-05 00:00:00') AND
  (created_at < '2019-02-05 00:00:00')

) as result 
WHERE (
  result.request_json->>'target' IS NOT NULL 
  OR result.request_json->>'return_to' IS NOT NULL
);

SELECT DISTINCT result.request_json->>'target' as target, 
                result.request_json->>'return_to' as return_to 
FROM (
  SELECT "request_params"::json as request_json 
  FROM "histories" 
  WHERE (created_at > '2019-02-05 00:00:00') AND
  (created_at < '2019-03-05 00:00:00')

) as result 
WHERE (
  result.request_json->>'target' IS NOT NULL 
  OR result.request_json->>'return_to' IS NOT NULL
);

SELECT DISTINCT result.request_json->>'target' as target, 
                result.request_json->>'return_to' as return_to 
FROM (
  SELECT "request_params"::json as request_json 
  FROM "histories" 
  WHERE (created_at > '2019-03-05 00:00:00') AND
  (created_at < '2019-04-05 00:00:00')

) as result 
WHERE (
  result.request_json->>'target' IS NOT NULL 
  OR result.request_json->>'return_to' IS NOT NULL
);

SELECT DISTINCT result.request_json->>'target' as target, 
                result.request_json->>'return_to' as return_to 
FROM (
  SELECT "request_params"::json as request_json 
  FROM "histories" 
  WHERE (created_at > '2019-04-05 00:00:00') AND
  (created_at < '2019-05-05 00:00:00')

) as result 
WHERE (
  result.request_json->>'target' IS NOT NULL 
  OR result.request_json->>'return_to' IS NOT NULL
);

SELECT DISTINCT result.request_json->>'target' as target, 
                result.request_json->>'return_to' as return_to 
FROM (
  SELECT "request_params"::json as request_json 
  FROM "histories" 
  WHERE (created_at > '2019-05-05 00:00:00') AND
  (created_at < '2019-06-05 00:00:00')

) as result 
WHERE (
  result.request_json->>'target' IS NOT NULL 
  OR result.request_json->>'return_to' IS NOT NULL
);

SELECT DISTINCT result.request_json->>'target' as target, 
                result.request_json->>'return_to' as return_to 
FROM (
  SELECT "request_params"::json as request_json 
  FROM "histories" 
  WHERE (created_at > '2019-06-05 00:00:00') AND
  (created_at < '2019-07-05 00:00:00')
) as result 
WHERE (
  result.request_json->>'target' IS NOT NULL 
  OR result.request_json->>'return_to' IS NOT NULL
);

SELECT DISTINCT result.request_json->>'target' as target, 
                result.request_json->>'return_to' as return_to 
FROM (
  SELECT "request_params"::json as request_json 
  FROM "histories" 
  WHERE (created_at > '2019-07-05 00:00:00') AND
  (created_at < '2019-08-05 00:00:00')
) as result 
WHERE (
  result.request_json->>'target' IS NOT NULL 
  OR result.request_json->>'return_to' IS NOT NULL
);

SELECT DISTINCT result.request_json->>'target' as target, 
                result.request_json->>'return_to' as return_to 
FROM (
  SELECT "request_params"::json as request_json 
  FROM "histories" 
  WHERE (created_at > '2019-08-05 00:00:00') AND
  (created_at < '2019-09-05 00:00:00')
) as result 
WHERE (
  result.request_json->>'target' IS NOT NULL 
  OR result.request_json->>'return_to' IS NOT NULL
);

SELECT DISTINCT result.request_json->>'target' as target, 
                result.request_json->>'return_to' as return_to 
FROM (
  SELECT "request_params"::json as request_json 
  FROM "histories" 
  WHERE (created_at > '2019-09-05 00:00:00') AND
  (created_at < '2019-10-05 00:00:00')
) as result 
WHERE (
  result.request_json->>'target' IS NOT NULL 
  OR result.request_json->>'return_to' IS NOT NULL
);

SELECT DISTINCT result.request_json->>'target' as target, 
                result.request_json->>'return_to' as return_to 
FROM (
  SELECT "request_params"::json as request_json 
  FROM "histories" 
  WHERE (created_at > '2019-10-05 00:00:00') AND
  (created_at < '2019-11-05 00:00:00')
) as result 
WHERE (
  result.request_json->>'target' IS NOT NULL 
  OR result.request_json->>'return_to' IS NOT NULL
);

SELECT DISTINCT result.request_json->>'target' as target, 
                result.request_json->>'return_to' as return_to 
FROM (
  SELECT "request_params"::json as request_json 
  FROM "histories" 
  WHERE (created_at > '2019-11-05 00:00:00') AND
  (created_at < '2019-12-05 00:00:00')
) as result 
WHERE (
  result.request_json->>'target' IS NOT NULL 
  OR result.request_json->>'return_to' IS NOT NULL
);

SELECT DISTINCT result.request_json->>'target' as target, 
                result.request_json->>'return_to' as return_to 
FROM (
  SELECT "request_params"::json as request_json 
  FROM "histories" 
  WHERE (created_at > '2019-12-05 00:00:00')
) as result 
WHERE (
  result.request_json->>'target' IS NOT NULL 
  OR result.request_json->>'return_to' IS NOT NULL
);