Skip to content

Instantly share code, notes, and snippets.

View mldyh's full-sized avatar

Maulidiyah Nur mldyh

  • Indonesia
View GitHub Profile
EXPLAIN analyze select
distinct on(cohort) to_char(cohort,'YYYY-MM-DD') as cohort,
sum(volume) over(partition by cohort) as val,
avg(volume) over(order by cohort rows between 12 preceding and current row) as avg_val
from loantape_autochek.mart_risk_traction
where category_key = any(values ('8a15842a0b5ba67ad588d48a23d6fcf6'),('d242718808a0e3a2076cb901a2dd7c6a'),('d2db1b7c7ebbc5234c39bff8b552bdf2'),('93714aef40317b2f06958993d9168205'),('4538ee5a74387ef244093da2691aeb8e'),('09e163bd749af3712f29fbd004f2a581'),('e2c01c144a92207944145b0f52bdaeb2'),('800b6758cbb60eefb0c86fe8ed612108'),('8633f9ee44e591429c0e38d0bf44d508'),('5952fb4da6c8bc146ff72ecdf4ebdfd3'),('a075db5d313f6ca3702d65965352d239'),('25e4640f1ffef6155d72aa90f2c74873'),('3f6dac7c83f810e9f8cd0d453cb42a2e'),('484485f7ac1d458189150da1d08df2f0'),('2ff8b05c4913d7404160f8f02258bd9a'),('9d9b8c7092131cb8fe5ec723313f45fe'),('a1db68ee120aa08022a8274dd1668b7a'),('bc9d319bcb655c8afdaf6d0aaa4635c4'),('e2c86f06a4b700f5f231ab0cf8c4fac5'),('05e26e9af868076b1d4334fca
@mldyh
mldyh / README.md
Last active April 7, 2022 11:13 — forked from lopspower/README.md
Hexadecimal color code for transparency

Hexadecimal color code for transparency

How to set transparency with hex value ?

For example, you want to set 40% alpha transparence to #000000 (black color), you need to add 66 like this #66000000.

All hex value from 100% to 0% alpha:

@mldyh
mldyh / BrowserDeviceInfo.js
Created October 8, 2021 06:53 — forked from TrevorJTClarke/BrowserDeviceInfo.js
A quick list of browsers and devices for use in testing. Chrome is used for all devices that need simulation.
var devices = [
{ name: 'Desktop - Huge', width: 2880, height: 1800, ratio: 2, type: 'desktop' },
{ name: 'Desktop - Extra Large', width: 1920, height: 1080, ratio: 1, type: 'desktop' },
{ name: 'Desktop - Large', width: 1440, height: 900, ratio: 1, type: 'desktop' },
{ name: 'Desktop - HiDPI', width: 1366, height: 768, ratio: 1, type: 'desktop' },
{ name: 'Desktop - MDPI', width: 1280, height: 800, ratio: 1, type: 'desktop' },
{ name: 'Laptop with HiDPI screen', width: 1440, height: 900, ratio: 2, type: 'desktop' },
{ name: 'Laptop with MDPI screen', width: 1280, height: 800, ratio: 1, type: 'desktop' },
{ name: 'Laptop with touch', width: 1280, height: 950, ratio: 1, type: 'desktop' },
{ name: 'Tablet - Portrait', width: 768, height: 1024, ratio: 1, type: 'tablet' },