SQL Noir

[slide42@jlai.lu]

Solve mysteries through SQL.

[omgitsaheadcrab@sh.itjust.works]

Good stuff

[ichbean@lemm.ee]

If you're new to SQL there's interactive Select Star SQL tutorial. And there's another detective — SQL Murder Mystery

[em2@lemmy.ml]

Heck yeah

[joebigelow@lemmy.ca]

I know what I'm doing at work today

[aurenkin@sh.itjust.works]

Push it to the LIMIT

[killeronthecorner@lemmy.world]

SELECT few FROM people WHERE gets_joke = 1

[slapnutsgt@lemmy.world]

I’m a rebel. I write all my sql in lowercase

[pruwybn@discuss.tchncs.de]

I tried to hit F5 to run a query and it refreshed the page lol

[anarchistartificer@slrpnk.net]

My gosh, these are incredible. Thank you for sharing them. I cried at Select Star; that is legitimate art.

[lud@lemm.ee]

Relevant:

[x00z@lemmy.world]

What would my few say?

[recursiveinsurgent@lemm.ee]

This seems like it was made specifically for me and my interests.

[nebeker@programming.dev]

That totally threw me off. “Literally unplayable,” as they say.

[tpyo@lemmy.world]

Alt text:

[tpyo@lemmy.world]

I have some time to kill before having to run some errands. I've started with the first one and it's pretty fun!

Said "fuck yeah" a couple times to myself when I got the answer right. I've not used SQL before but I've got a decent grasp (as in I get the basics) on programming languages so it's somewhat intuitive to me

Thanks for the links!! I look forward to continuing when I get back

[shasta@lemm.ee]

Yeah we have IDEs to color keywords for us these days. Caps is just extra work

[diemartin@sh.itjust.works]

Capital letters are bigger, thus they use bigger bytes and use too much disk space and memory. That's why most programming languages use lowercase, and why the most common loop variable is i.

[dreugeworst@lemmy.ml]

seems like there's an issue with case 3. the person_id and from surveillance_records doesn't match up with the person_id in the hotel_checkins table when joined on hotel-checkin_id

[anzo@programming.dev]

And why untyped languages are better at managing memory too. Less characters ftw!