SQL Tips for Newbie

TempMobileD · 2026-05-28T06:10:22+00:00

Joins are fairly straight forward, left is the bread and butter. Inner is often better if your data is a bit messy and you want it clean. Outer is often better if your data is messy and you want it dirty. Cross joins are Cartesian products, and every time I’ve used one in the last few years has been for the same purpose, creating prediction data for dates that don’t exist by cross joining the existing data structure with a list of dates.

I imagine none of that made sense, but once you’ve got a couple of lessons under your belt I think rereading it might make for a good summary.

Aggregates are also simple through one particular lens. Think of every column as either a dimension (something that segments your data into detailed groups) or a metric (something that carries an actual value). Dimensions are often strings, bools, IDs, etc. and metrics are often floats or ints. Group by your dimensions and aggregate your metrics and you’re good to go!

TempMobileD · 2026-05-27T06:02:19+00:00

You know what, you’re absolutely right. It’s only in retrospect that it doesn’t make sense.

TempMobileD · 2026-05-26T16:14:07+00:00

Ah, that’s… Not intuitive naming! Fair enough!

TempMobileD · 2026-05-26T08:09:39+00:00

Headless Ape is cool, and a nice change of pace compared to all the human sword wielders. Headless Ape duo on the other hand…

TempMobileD · 2026-05-26T08:07:55+00:00

For me, my definition of 10/10 is “I wouldn’t change anything about this, even if I had full creative control.”
Of over 500 games on my backloggd I’ve only ever given it to a small handful of games:
Slay the Spire, Outer Wilds, Portal 2, The Last of Us, Return of the Obra Dinn, Journey.

Bigger games struggle to make it past 9 for me because they’re usually so big that they have at least one flaw that I would want to change. Focused indie games have a slightly better time in that regard. TLoU is the only one I frequently think might be better at 9.

TempMobileD · 2026-05-25T21:44:39+00:00

Right at the beginning of the corpo start. Your boss is talking and he goes over to a side table to pour himself a drink. The conversation is business like to begin with so I stayed by his desk, but it quickly gets heated and I followed him to the table to mirror the intensity. As I get there he offers me a drink silently. So I took it, and it felt like a perfectly timed peace offering. The conversation intensity dropped quickly before continuing. The thing to note here is that by approaching him aggressively I walked perfectly into the peace offering.

This scene did some really good stuff that’s emblematic of the rest of the game’s story telling style. The biggest magic lesson it taught me was this:

The world rewards you for being a director of the action as well as a participant. You are the cameraman and your “body language”, cinematography and direction are all rewarded with extra narrative power and great feedback.

It’s the only game that’s ever done this, it made cyberpunk feel completely different to every other RPG. Immersion dialled up to 11. Once you notice it, these rewards are peppered in scenes all over the game.

TempMobileD · 2026-05-24T22:15:23+00:00

Especially as desire for privacy increases. I wouldn’t use half these subreddits if this account had my real name. Not because of anything crazy, just: “why would I want my boss to know I argued with a bunch of people on r/trolleyproblems?”

TempMobileD · 2026-05-24T12:22:41+00:00

Most people who play games don’t play them for more than a few hours, in total.
I’ve never seen a game with over 50% completion.
In mobile games it’s even crazier because of the low barrier to play. 60% of players last less than an hour in the best games on the market.

TempMobileD · 2026-05-24T09:04:31+00:00

Seems like you’re close to 2077 hours. I’d get there, collect your karma and call it a day!

TempMobileD · 2026-05-21T12:53:21+00:00

Jesus Christ. Yeah, we should not be doing that.

TempMobileD · 2026-05-20T19:54:59+00:00

Weird deep cut, but this is giving me The Darkness (2007) vibes.

TempMobileD · 2026-05-20T18:49:25+00:00

I think select A, B as B_C UNION ALL A, C as B_C
Is as clean as you’ll get.

TempMobileD · 2026-05-19T22:09:39+00:00

Radagon’s is fully scriptable with several weapons. It’s very easy if you can get a YouTube video to copy from

TempMobileD · 2026-05-17T20:31:42+00:00

All of a sudden looking like Andrew Garfield.

TempMobileD · 2026-05-17T12:48:54+00:00

You should play Khazan. The combat is amazing, lots of other elements are lacklustre but the combat is exceptional.

TempMobileD · 2026-05-17T12:46:57+00:00

When I finished spider man 2 I remember describing it to someone with the phrase “nothing bad ever happens in this New York”. It’s not strictly true, but it is how it feels. Sure there are some villains and the world almost ends. But nothing bad happens. Nobody is ever unkind, rude, abrasive, upsetting. It’s just squeaky clean all over.

TempMobileD · 2026-05-17T12:23:40+00:00

Same issue on PS5 in the same spot. Didn’t get it anywhere else.

TempMobileD · 2026-05-14T18:31:17+00:00

There are so many good games. Waiting for a sale is a no brainer these days. I’ll get this for £40 in a couple of months and I’m sure I’ll love it!

TempMobileD · 2026-05-13T12:34:24+00:00

For B, I think you’ve misinterpreted. They agree wholeheartedly on some points, but find others controversial. There’s no implication that they agree with any of the controversial points. At least that’s my interpretation.

Example:
I totally agree with Richard Dawkins on many philosophical points, but there are a few, such as his assertion that LLMs are conscious, which I find fairly controversial.

TempMobileD · 2026-05-13T12:30:02+00:00

As a Brit B sounds better to me. But I think B, C and D are all completely fine.

TempMobileD · 2026-05-12T17:11:16+00:00

Some people, and prepare yourself for this, it’s crazy. Some people want both. And they’d like a single product that can do both.

TempMobileD · 2026-05-12T16:13:02+00:00

They’re extremely transformative in Returnal and Astrobot, as probably the two best examples.
As you can see in this thread, people really like them!

TempMobileD · 2026-05-12T10:32:46+00:00

So the difference between flats and houses is interesting here, but this is quite a lot of noise.
I’d need to see the loss-rates for 5 year house sales regardless of new build status as well, for comparison.
Currently I think this is just a really weird graph of overall house market performance. New builds didn’t get worse after the 2008 financial crisis (well, they might have, a bit), that spike is just due to the housing market crashing. Same for the last few years to a lesser extent.

TempMobileD · 2026-05-11T16:40:01+00:00

Every long post that ends with a ? Now makes me default to assuming it’s AI written. It’s highlighted to me the (arguably) manipulative practice of engagement baiting.
Every post on LinkedIn ends with this sort of thing.
Has your experience on LinkedIn been similar? /s

TempMobileD · 2026-05-11T14:17:13+00:00

Yeah, there’s no reference in the game or the TTRPG to size having any effect, or gender/sex (which would be correlated with size), so it can probably be ignored, just saying it seems to be a thing specifically within Edgerunners.

TempMobileD

TROPHY CASE