kochoru

kochoru / .gitlab-ci.yml

Created February 4, 2019 03:30

GitLab CIでserverless frameworkを使ってnode8.10のLambda Functionをデプロイする

	image: lambci/lambda:build-nodejs8.10

	deploy:
	stage: deploy
	script:
	- aws configure set aws_access_key_id $AWS_ACCESS_KEY_ID --profile serverless-agent
	- aws configure set aws_secret_access_key $AWS_SECRET_ACCESS_KEY --profile serverless-agent
	- npm i -g serverless
	- npm i
	- npm run deploy

kochoru / age-analyzer-from-birthday.sql

Last active November 2, 2018 06:26

PostgreSQLで誕生日からユーザの年代を集計するSQL(テーブル名:USERS, 誕生日列名:birthdayと仮定)

	SELECT
	CASE
	WHEN date_part('year', age(birthday)) BETWEEN 1 AND 19 THEN '10代'
	WHEN date_part('year', age(birthday)) BETWEEN 20 AND 29 THEN '20代'
	WHEN date_part('year', age(birthday)) BETWEEN 30 AND 39 THEN '30代'
	WHEN date_part('year', age(birthday)) BETWEEN 40 AND 49 THEN '40代'
	WHEN date_part('year', age(birthday)) BETWEEN 50 AND 59 THEN '50代'
	WHEN date_part('year', age(birthday)) BETWEEN 60 AND 69 THEN '60代'
	WHEN date_part('year', age(birthday)) BETWEEN 70 AND 79 THEN '70代'
	WHEN date_part('year', age(birthday)) BETWEEN 80 AND 89 THEN '80代'