Skip to content

Instantly share code, notes, and snippets.

View colinxfleming's full-sized avatar

Colin colinxfleming

35 followers · 32 following
View GitHub Profile
@colinxfleming
colinxfleming / advent_of_code_2022_04.sql
Created December 4, 2022 20:35
Advent of Code, Day 4, SQL Only
with base as (
select
'71-89,66-70
24-70,23-55
19-85,18-86
50-90,50-95
55-55,56-72
3-65,5-66
98-99,66-99
14-67,14-14
@colinxfleming
colinxfleming / advent_of_code_2022_03.sql
Created December 4, 2022 01:44
Advent of Code, Day 3, SQL Only
with base as (
select
'NLBLfrNNLvqwbMfDqSjSzzSJjjggcdVs
lTRGPPZnRRHszcsZdSsccZ
CFTTFtFHTtCtDDzrmBtrBD
BJldgBWnRgWNWtllSlWShMcLcVSvVjbVVVvDVVVL
HFGFwqQPQGwHrTFpwmThMbDDVcVmLvvshj
HrpHrGPZZCQrfqlNdtMlzfMltlgn
hQLhBtBtQNQjBjNLvtLjzLJpWbjJdppSwjpCCplllJdj
FGFsmccSPTVPfVVHpJJgwlJwwWJWpCmR
@colinxfleming
colinxfleming / advent_of_code_2022_02.sql
Last active December 2, 2022 21:48
Advent of Code Day 2, in SQL
with base as (
select
'B Z
C Z
B X
A Y
B X
B X
A X
B Z
@colinxfleming
colinxfleming / advent_of_code_2022_01.sql
Last active December 2, 2022 20:51
Advent of Code Day 1 - SQL Only
-- Q1
-- Take the raw data as a CTE
with base as (
select
'22243
11899
1696
2595
5331
@colinxfleming
colinxfleming / keybase.md
Created July 12, 2018 01:10

Keybase proof

I hereby claim:

  • I am colinxfleming on github.
  • I am c3flemin (https://keybase.io/c3flemin) on keybase.
  • I have a public key ASDMjtV0brp0DpEEP5ScPnjQkruzU_IR0VYuI8OjuotMPgo

To claim this, I am signing this object: