Solve mysteries through SQL.
You must log in or register to comment.
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
Alt text:
Heck yeah
Push it to the
LIMITSELECT few FROM people WHERE gets_joke = 1
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.
If you’re new to SQL there’s interactive Select Star SQL tutorial. And there’s another detective — SQL Murder Mystery
