Stats
15,384
reputation
261k
reached
911
answers
1
question
Loading…
About
Who I am? Data science enthusiast. Self made man with strong enterpreneurial spirit. Been learning in the field since 2016. Enjoy playing with and around data. Artist.
Fulfillment comes from? Being challenged and learn in the process. Save people's time (and money).
Topics of my answers on SO? SQL Querying, Regex, Python. My favourites:
- SQL and Dates: sql query to avg over a fixed range over the entire data set
- SQL Delete with Joins: How to make rows from two table "Cancel" each other by columns values(SQL server)
- SQL Dynamic Querying: Join into pivot (?)
- SQL Gaps and Islands: how to get last known contiguous value in postgres ltree field?
- SQL Recursive Querying: Finding the amount of steps between values in SQL
- SQL with JSON: How return different type values in MySQL case statement
- SQL in MySQL 5.7: Is there a way to only show the first date of a 5 day streak?
- Regex: Regex to match any title case strings in markdown headings
- Python: How do I get lst1 to be alphabetical while being in the same order as lst2
![I am nerdier than 96% of all people. Are you a nerd? Click here to take the Nerd Test, get nerdy images and jokes, and talk on the nerd forum!](https://cdn.statically.io/img/www.nerdtests.com/images/ft/nq/5ff9020d2a.gif)
Badges
View all badges
6
gold badges
-
Copy EditorJun 30, 2022
-
Steward
× 2Jun 5, 2023 -
Unsung HeroJun 12, 2022
20
silver badges
-
sqlJan 29, 2023
-
RefinerJul 4, 2022
-
ArchaeologistMay 15, 2022
40
bronze badges
-
postgresqlApr 5, 2023
-
regexJun 1, 2023
-
sql-serverJun 3, 2023
Top tags
View all tags
583
Score
599
Posts
66
Posts %
212
Score
262
Posts
29
Posts %
154
Score
136
Posts
15
Posts %
117
Score
118
Posts
13
Posts %
104
Score
118
Posts
13
Posts %
104
Score
107
Posts
12
Posts %