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
this post was submitted on 27 Feb 2025
253 points (98.5% liked)
Programming
18422 readers
393 users here now
Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!
Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.
Hope you enjoy the instance!
Rules
Rules
- Follow the programming.dev instance rules
- Keep content related to programming in some way
- If you're posting long videos try to add in some form of tldr for those who don't want to watch videos
Wormhole
Follow the wormhole through a path of communities [email protected]
founded 2 years ago
MODERATORS
Heck yeah
Push it to the LIMIT
SELECT few FROM people WHERE gets_joke = 1
What would my few say?
I’m a rebel. I write all my sql in lowercase
Yeah we have IDEs to color keywords for us these days. Caps is just extra work
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.
I tried to hit F5 to run a query and it refreshed the page lol
edit: I'm also slightly annoyed that the table names are a mix of singular and plural
That totally threw me off. “Literally unplayable,” as they say.
If you're new to SQL there's interactive Select Star SQL tutorial. And there's another detective — SQL Murder Mystery
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
I know what I'm doing at work today
My gosh, these are incredible. Thank you for sharing them. I cried at Select Star; that is legitimate art.
This seems like it was made specifically for me and my interests.
Good stuff