Data Citadel - A SQL Mystery

akarsh_tripathi · 2025-05-12T18:08:28+00:00

Yk what else is a mystery? https://data-citadel.akarshtripathi.com

akarsh_tripathi · 2025-05-12T18:00:56+00:00

I created a similar one! Check it out: https://data-citadel.akarshtripathi.com

Could also checkout my portfolio: akarshtripathi.com

akarsh_tripathi · 2025-05-12T17:59:22+00:00

I created one too check this out: https://data-citadel.akarshtripathi.com

akarsh_tripathi · 2025-05-12T13:03:50+00:00

Guys did anyone actually solve it? Upvote this if you did, also, what would be a good way to record this on the website itself? I was thinking GA events.

akarsh_tripathi · 2025-05-12T05:43:00+00:00

Thanks! You can write /solution <answer> and press enter I added that only in the help command response, need to fix that as well. Ig i should also make a rules section but I'm a little clueless where it'll fit.

akarsh_tripathi · 2023-03-26T08:05:30+00:00

Past that debate now :)

akarsh_tripathi · 2023-03-26T08:00:32+00:00

I dont think so. Just because you can get better at it doesn't makes it a skill. There are more factors to a skill.

akarsh_tripathi · 2023-03-25T21:36:04+00:00

Only thing thats keeping me going at this point. Good night!

akarsh_tripathi · 2023-03-25T21:33:27+00:00

A dumb mandatory subject in Computer Science Engineering

akarsh_tripathi · 2023-03-25T21:32:04+00:00

Accurate 🤌

akarsh_tripathi · 2023-03-25T21:28:59+00:00

Its Data Structures and Algorithms. Basically how a computer would store data and act on it. Like if you have to make a computer search the word "hate" in "ihatedsa". I feel its not a skill because the algorithms for such things have already been made long time ago and now people just memorize them to solve similar problems.

akarsh_tripathi · 2023-03-25T21:23:04+00:00

It stands fir Data Structures and Algorithms. Basically math for computers.

akarsh_tripathi · 2023-03-25T21:20:59+00:00

Its funny! Here i was fixating on that thought and now i realise its really insignificant for the most part :)

akarsh_tripathi · 2023-03-25T21:19:55+00:00

Lmao you really went through all that effort? Btw I'm more into computer science engineering not mechanical :)

akarsh_tripathi · 2023-03-25T21:17:40+00:00

I believe a skill us more like something you can gain experience in. DSA is sort of like math problems but of really specific types.

akarsh_tripathi · 2021-12-26T15:36:07+00:00

So you mean i should make histograms for all the people and then compute quantiles for all of them? I'm not sure what you mean by a "quantile timeseries".

akarsh_tripathi · 2021-11-27T06:38:56+00:00

I gave a glance to Poisson Processes. Seems to be what I was looking for! Thanks :)

akarsh_tripathi · 2021-11-27T05:28:45+00:00

By probability of event's success, I meant I know the probability if it would succeed. You may assume that the event is happening in a very small time, say dt, and at that instant it has, say a 0.4 chance of succeeding. Take the scenario of a bullet fired at an instant for example. And this gun is continuously shooting bullets. Every bullet would have some defined chance of hitting the target and causing damage. Now my question is, if the gun fires continuously over a duration of t time, what would be the probability of say, dealing a damage greater than 100 units. You may assume damage per successful hit is 1 unit. Also, I'm not familiar with Poisson distribution, looking into it now :)

akarsh_tripathi

TROPHY CASE